Hello @sukanta_biswas ,
First of all, I really appreciate your response. Here is the information you requested:
Schema:
Is this the cursor’s column list you requested?
OFSDEV7
SQL> set serveroutput on
SQL> variable P_CUR refcursor
SQL> DECLARE
P_CUR SYS_REFCURSOR;
BEGIN
SYSADM.FD_NFE_ARCS_PENDING_ITEMS(F_OPRID => 'JSCHMITT', P_CUR => P_CUR);
:P_CUR := P_CUR ;
END;
PL/SQL procedure successfully completed.
SQL> print P_CUR
APPROVAL_OPRID RESULT
------------------------------ ------
JSCHMITT True
1 row selected.
Here is what the object look like after hardcoding it:
