OraFAQ Forum: SQL & PL/SQL » How to get Out parameter from Oracle stored proc with a package by ADO (Visual basic )

Home » SQL & PL/SQL » SQL & PL/SQL » How to get Out parameter from Oracle stored proc with a package by ADO (Visual basic )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get Out parameter from Oracle stored proc with a package by ADO (Visual basic ) [message #1744]

Sat, 25 May 2002 22:06

jitendra
Messages: 11
Registered: January 2002

Junior Member

Hi ,
For my application I want to return a ref cursor and another out paramater from a Oracle stored procedure with in a package.I am able to retrieve the refcursor wit the help of ADO(Visual Basic). But not able to get the Out parameter.I am using ADO command object for executing the stored procedure.But I am able to get an Out parameter(execpt Refcursor) from a simple stored procedure (with out a package).Where as if the procedure is with in a package , I am not able to catch the out parameter. Please let me know how to solve this problem .

Report message to a moderator