back to homepage

separate java application Free Articles

Oracle 10G Development & Design: Heterogeneous Database Access

The goal of today’s article is heterogeneous database access example from Oracle stored procedures to MS SQL Server 2000. The sample dataset will be pulled from MS CRM database. We’ll use rich functionality of Oracle stored procedures with Java utilization to access Microsoft CRM quotes via cursors mechanism. Our sample will have two parts - first we’ll model complete functionality of stored procedure in separate Java application and then we’ll transfer the code into Oracle RDBMS.

Read More