DAAB with Oracle ref cursors

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

Can anybody send me an example of calling an Oracle stored procedure which returns a ref cursor using Enterprise Library DAAB? More precisely, I need to know how to call both procedures:

PROCEDURE GET_USER_BYID( P_USER_ID_IN IN NUMBER, cur_OUT OUT REF CURSOR)

and functons:

FUNCTION GET_USER_BYID( P_USER_ID_IN NUMBER ) RETURN REF CURSOR


Any help would be greatly appreciated.

Thanks,
Dmitry.
.

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)
  • Re: Oracle Rollback causing error with .NET 1.1
    ... I am calling a DBMS_Transaction.ReadWrite; and later Rollback; from an ... Oracle Stored Procedure. ...
    (microsoft.public.dotnet.framework.adonet)
  • Oracle Stored Procedure
    ... What is the correct syntax for calling an oracle stored procedure and ... getting a retrun value? ... I created a simple procedure on my oracle database ...
    (comp.lang.php)
  • 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)