How to Run the Procedure

Question

Here the Package    CREATE OR REPLACE PACKAGE G PKG REFCUR AS     TYPE rcDataCursor IS REF CURSOR  END    Let s consider the PROC    Create procedure gokul proc      pId in number      pName in varchar2      OutCur OUT G PKG REFCUR rcDataCursor   is BEGIN     Open OutCur For         select   from gokul table ob          where ob active staus- Y  AND ob id pId AND ob name pNname  END    Here is my question  How can I execute this procedure   If there isn t an OutCur parameter  then I can execute like this    EXEC gokul proc 1  GOKUL      but  the problem is OutCur  I don t know which value to pass here   For example  EXEC gokul proc 1  GOKUL              I just need to know what value to pass as a argument for the procedure

User · Answer

In SQL Plus   VAR rc REFCURSOR EXEC gokul proc 1  GOKUL    rc   print rc

[oracle] How to Run the Procedure?

Examples related to oracle

Examples related to plsql