ORA-01023: Cursor context not found in combination with Microsoft OLE DB -2147467259

[BeeJay_74]

Hello,

I've build a webapplication using ASP on a ORACLE database. (ASP, Oracle 10G, windows2003server)

In several test environments everything works fine.

In production however I keep getting this error:
ORA-01023: Cursor context not found (Invalid cursor number)
Source: Microsoft OLE DB Provider for Oracle number: -2147467259

The error appears when I execute a stored procedure in the following code snippet

dbObject.Clear
' Set stored procedure name
dbObject.SP = "NAME"

(15 parameter creations)
dbObject.CreateParameter xxxxxxxxxxxxxxxxxxxxxxx

dbObject.ExecuteSP

Only executing this particular stored procedure creates this problem. And it only occurs on one server (unfortunately the production server) On all testservers its working just fine.
I've tested already a lot of things. I'm running the code of the stored procedure directly on the database and that works fine. So I'm pretty desperate.

Regards,

Bart Koren

[BeeJay_74]

I just found out that the test server database is an ORACLE 10G XE and de produktionserver is a standard ORACLE 10G database. I hope this doesnt cause the problem.

[BeeJay_74]

I've solved the problem and want to write down the sollution here too. Maybe its helpfull for somebody.
I call a stored procedure with about 13 parameters from my asp page. I use one in/out parameter, 9 in parameters and 3 out parameters. And the out parameters are the problem. It seems that only 2 out parameters of the type VARCHAR2 or VARIANT are supported. Using more than 2 out parameters of the type varchar2 or variant causes the error ORA-01023: Cursor context not found (Invalid cursor number)
Source: Microsoft OLE DB Provider for Oracle number: -2147467259.
Strangely it only does that on one server.
Now I concatenate two OUT parameters first and later in de code SPLIT them again. This works fine.

[PAVB]

Nice research, Thank you also for posting the solution.
Congrats! way to go.