1 Reply Latest reply: Jul 18, 2014 1:33 PM by Jason_(A_Non) RSS

    Function returns Ref cursor

    AAG

      Hello,

       

      I have a function (with 5 IN parameters) in a pkg, which returns variable of TYPE refcsr IS REF CURSOR;

       

      To troubleshoot an issue, i wanted to call this function from sqlplus by passing those 5 parameters explicitly.

      Since this return type ref cursor, i am unable to do so. (Number and Varchar i know how to return).

       

      Help with any example is greatly appreciated. !

       

      I tried this :

       

      variable var refcursor;

      execute :var := pkg.function_nm(parm1, parm2.. parm5);

       

      pring var;

       

      I am unable to do so. I think i am trying a wrong logic.

       

      Regards,

      -AAG