This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
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
 
GeeCON Prague 2014
 
subject: Stored Procedure Making Two different Server Database Call