ADO stored procedures from VC++ using ORACLE 
Author Message
 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?



Fri, 28 Feb 2003 21:10:28 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Oracle stored procedure and input arrays using ADO and VB6

2. Error calling Oracle store procedures using ADO

3. Recordsets Using ADO and Oracle Stored Procedures

4. Oracle stored procedures/functions using ADO

5. oracle's stored procedure from vb using ADO

6. executing a stored procedure in oracle using ADO

7. Unable to get Output data using VB, Ado 2.1 and Oracle Stored procedure

8. HELP ==>Oracle Stored Procedure using ADO(VB)

9. HELP ==>Oracle Stored Procedure(PACKAGE) using ADO(VB)

10. ado recordsets from stored procedures, stored procedures have input parameters

11. ADO: Calling Multiple Oracle Stored Procedures at once

12. Returning resultsets from Oracle stored procedures via ADO?

 

 
Powered by phpBB® Forum Software