December 28, 2004 at 8:30 am
I have a situation with two databases. One is SQL Server 2000 (my responsibility) and the other is an Oracle 9i database (someone else's responsibility). The Oracle database has several stored procedures that I need to call in order to transfer some information from SQL Server to Oracle.
My concern is over the stored procedure signatures. Many of them have parameters that are arrays/tables. I have worked with these types of stored procedures before, writing .NET code using the Oracle data provider for .NET to get data in and out of the array/table parameters.
If I wanted to call these procedures from T-SQL instead of from a .NET application, is there any way to pass array/table parameters? If not, is writing extended stored procedures my only other option? Can .NET be used in extended stored procedures or do I need to write regular C++ code?
Thanks in advance for your assistance!
December 29, 2004 at 3:20 pm
Follow this link, it might help you.
January 1, 2005 at 9:24 pm
Ok. I have done some digging and it would appear that there is no way to call an Oracle stored procedure from inside SQL Server. So, I have to move this function into an extended stored procedure.
Can an extended stored procedure be written using C++ .NET?
Anyone have experience with trying this? Thanks...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply