
ADO stored procedures from VC++ using ORACLE
Problem with:
Calls of Stored-Procedures via ADO OLE DB Oracle. The problem occurs if
the procedure also uses output parameters (with return values)
Description:
If a return value is used in a procedure, the call of the procedure with ADO
sometimes results in strange problems, like an ORA-04020 error (deadlock),
or a crash of the task if the database disconnect command is called!
Configuration:
Windows NT 4.0 with SP6
Oracle 8.0.5 and 8.1.5
ADO 2.1 (Provider=MSDASQL)
MS-Visual C++ 6.0 with SP4
Questions:
Who has made the same or similar experience?
Is there a solution like an upgrade, a patch or a workaround for this
specific problem available?