Connection to different databases from Oracle Java Stored Procedure

Connection to different databases from Oracle Java Stored Procedure

Post by murat.arsl » Sat, 30 Sep 2006 21:48:56


Hi,

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

Thanks
 
 
 

Connection to different databases from Oracle Java Stored Procedure

Post by kuassi.men » Mon, 02 Oct 2006 07:51:13

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://www.yqcomputer.com/


Kuassi