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:16:07 GMT  
 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 22:33:41 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Problems calling Oracle stored procedures from VC++ over ADO(OLEDB)

2. Help with VC++ to Oracle using Stored Procedures

3. ADO, Oracle stored procedures and struct

4. ADO, Oracle stored procedures and struct

5. execv function fails when used as an Oracle external stored procedure

6. Calling Oracle stored procedures using MFC's classes

7. Calling Oracle stored procedure from VC++

8. Problem with transfer parameters to a stored procedure using ADO

9. callling stored procedures using ADO .NET

10. Passing Record Type from VC ADO to Stored Procedure

11. ADO : OUTPUT VALUE from a Stored procedure in VC++

12. Storing date/time value on SQL server with milliseconds resolution using vc++ and ado 2.0

 

 
Powered by phpBB® Forum Software