Connection to different databases from Oracle Java Stored Procedure

Thread view:

Enable EMail Alerts

Start New Thread

murat.arslan@turkcell.com.tr - 29 Sep 2006 13:48 GMT

Hi,

Is it possible to make JDBC connection to a Sybase DB from whithin an
Oracle 9i java stored procedure.

Thanks

Reply to this Message

kuassi.mensah@gmail.com - 30 Sep 2006 23:51 GMT

Yes, provided you have a pure Java JDBC drivers (type 4) of the target
database.
I have a SQL Server example that you can easily replicate for Sybase in
book (look for "JDBC Call-Out to non-Oracle database" in chapter 4).
http://db360.blogspot.com/2006/08/oracle-database-programming-using-java_01.html

Kuassi

> Hi,
>
> Is it possible to make JDBC connection to a Sybase DB from whithin an
> Oracle 9i java stored procedure.
>
> Thanks

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...