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);
I am unable to do so. I think i am trying a wrong logic.