Home » SQL & PL/SQL » SQL & PL/SQL » Re: Ref Cursor Error
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.

----------------------------------------------------------------------
Previous Topic: Dynamic sql bulk insert
Next Topic: Program taking a lot of time ..... needs optimization
Goto Forum:
  


Current Time: Fri Mar 29 06:19:54 CDT 2024