Using Oracle REF CURSORs with BDE&Delphi 5

Murat Okay

Delphi Developer

Mon, 16 Feb 2004 04:21:07 GMT

Using Oracle REF CURSORs with BDE&Delphi 5

This question may be redundant but I didn't manage to find the answer among
1200 questions.

How can we use Oracle's REF CURSORs in Delphi 5 with BDE or ADO?
I can return a REF CURSOR parameter from Oracle stored procedure. But I
don't know how to use it in my code.
Thanks in advance...

Murat OKAY

John Pierc

Delphi Developer

Mon, 16 Feb 2004 04:35:29 GMT

Re:Using Oracle REF CURSORs with BDE&Delphi 5

Make sure the procedure declares the REF CURSOR as type IN OUT. Then
declare a parameter IN OUT of type ftCursor in the TStoredProc. OPEN the
SP, and then read the output in a loop, just as though it were a table
or view.

John Pierce

Other Threads

1. Using TADOStoredProc to get Oracle Ref Cursor

2. Modifiable ORACLE datasets using ref cursor

3. Delphi and ORACLE REF CURSOR

4. Oracle REF CURSOR, ADO, and DELPHI

5. Pleeease : Oracle Stored Procs, REF CURSOR and DELPHI

6. Oracle 8.1.7 and packaged stored procedure parameters (REF CURSORS)

7. ADO Express and Oracle REF CURSORS

8. Oracle and Ref Cursor

9. Oracle Ref Cursor and ADO Express

10. Oracle Ref Cursor and ADO