Recent content by JamesEricAndy

  1. J

    Ora 10G client failure on Ref Cursor Stored Proc

    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...
  2. J

    Ora 10G client failure on Ref Cursor Stored Proc

    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...
  3. J

    DBMS_Output.Get_Lines result is empty

    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...
  4. J

    Package wizard for Store Procs w/o Package

    Thanks for confirming what I suspected.
  5. J

    Package wizard for Store Procs w/o Package

    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...
Back
Top