Home » SQL & PL/SQL » SQL & PL/SQL » Re: Ref Cursor Error
Re: Ref Cursor Error [message #36778] Thu, 20 December 2001 01:10
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: Thu May 23 17:58:22 CDT 2024