We have NOT tested the oracle 10g client against the 9i database.
However, I am now able to call the previously failing Stored procedure by turning off the following property on the TOracleSession:
"StatementCache=False".
Setting it to True works fine with the Oracle 8 client against...
I've been succesfully calling a Stored Procedure thru DOA 4.0.7 that returns a "Reference Cursor" using Oracle 8i client against both an Oracle 9 & Oracle 10 database. When we replaced the Oracle 8i Client with the Oracle 10g client, the Oracle client generated the following exception on the...
I executed an Oracle script that contained DBMS_Output.Put_Line() commands.
I can then fetch the lines in DBMS_Output by using the DOA wizard generated code
TDBMS_Output.Get_Line in a loop.
However, I can NOT fetch the DBMS_Output lines using the DOA wizard generated code...
I've used the DOA Package Wizard to create the wrapper code for Stored Procs that are contained within Packages.
Some of the Stored Procs in the database I am working on are NOT contained within a Package.
Is there any tool similar to the "Package Wizard" that will generate the wrapper...