How to create Stored Procedure on Oracle 9i?
Posted on 2008-11-07
I have to write a stored procedure on Oracle 9i Database.
In this SP, I will have to talk to two different databases other than the one on which it is written.
Do I need to have DB links created between the database on which this SP is written and the other two databases?
Out of the other two databases, one is a MSSQL database. Will there be any limitations for the stored procedure if it has to talk to a non Oracle Database?