File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Stored Procedure Making Two different Server Database Call Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Stored Procedure Making Two different Server Database Call" Watch "Stored Procedure Making Two different Server Database Call" New topic
Author

Stored Procedure Making Two different Server Database Call

nazzy khan
Ranch Hand

Joined: May 06, 2010
Posts: 39

Hi,

I have one stored procedure which makes call to three sybase databases (all are in same server)

There is an sp GetAllFunds compiled on one of sybase db and this sp fetches data from two other sybase database using db2..<table_name> & db3..<table_name>

Now one of my sybase database is moving to Oracle (different database server), so what change is required in that stored procedure in order to get data now from oracle.

SP is still on sybase and it will now fetch some data from sybase & some from oracle.

Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
Hi nazzy,

I did not work with sybase but I am sure it supports connectivity to an other database. The opposite is possible with oracle dblink to sybase. You have search in sybase documentation.

Regards,
Fatih.
nazzy khan
Ranch Hand

Joined: May 06, 2010
Posts: 39

Hi Fatih,

Thanks for your reply. I will explore it further.

Regards,
nazzy
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Stored Procedure Making Two different Server Database Call
 
Similar Threads
Database Metadata
set chained mode off ???
SQL Sysntax Error.
Using JDBC for a remote call in Oracle
Speed Up JDBC Process with Oracle and Sybase