How to get multi ref cursors returned by an Oracle stored procedure?

Dear all,

I have an Oracle stored procedure like the following:

create or replace procedure return_multi_cursor_test(
ref cursor out c1,
ref cursor out c2) as
begin
open c1 for 'select * from tab1';
open c2 for 'select * from tab2';
end;
/

How can I get these 2 returned cursors and cast them to datasets in Delphi
6? Thanks for any clues.

Regards,
George
.

Relevant Pages

  • Ruby sample code for PLSQL REF CURSORS
    ... I am having hard time to find a sample that shows me how to return an OUT ... REF CURSOR from my oracle stored procedure to my python program. ...
    (comp.lang.ruby)
  • Returning Xml as text from Oracle Stored Proc
    ... I am returning Xml from an oracle stored procedure using the Oracle managed provider, using a ref cursor to fill a dataset. ... The Xml is stored as a varchar on the database, but when I retrieve it, all newline tab and double quote characters have been escaped. ...
    (microsoft.public.dotnet.framework.adonet)
  • Accessing Oracle Ref cursor with Ole DB provider for Oracle
    ... I'd like to know, if it is possible, how I could access a ref cursor, ... returned by an Oracle stored procedure, in my VB.net application using the ... so I don't know wich type I can use for my OUTPUT parameter ... Cedric FABIOUX ...
    (microsoft.public.dotnet.framework)
  • DAAB with Oracle ref cursors
    ... Can anybody send me an example of calling an Oracle stored procedure which returns a ref cursor using Enterprise Library DAAB? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Recordsets and Ref Cursors
    ... I have problem with respect to ref cursor. ... My DB ask me to pass data (about 30 fileds) to oracle stored procedure by ... Jaiganesh ...
    (microsoft.public.dotnet.framework.adonet)