ORA-01023: Cursor context not found in combination with Microsoft OLE DB -2147467259
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