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

    Function returns Ref cursor




      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.