Re: Ref Cursor Error [message #36778] |
Thu, 20 December 2001 01:10 |
wsteinme
Messages: 1 Registered: December 2001
|
Junior Member |
|
|
Recently, I had to convert a SQL Server 7 database over to Oracle 9i. I had a similar problem with calling the stored procedures.
I found the fix to my problem, it might work for you. I added to the connection string PLSQLRSet=1. This option apparently tells ADO to call the oracle stored procedure a certain way.
sConnect = "Data Source=acct;User ID=test; Password=test;PLSQLRSet=1;"
Hopefully, you figured it out by now. Or this will work for you.
----------------------------------------------------------------------
|
|
|