This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Stored Procedure Making Two different Server Database Call

 
nazzy khan
Ranch Hand
Posts: 39
Android Eclipse IDE Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 182
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 39
Android Eclipse IDE Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Fatih,

Thanks for your reply. I will explore it further.

Regards,
nazzy
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic