I have a stored procedure with 2 input parameters and out refcursor , it is working fine and i am able to get the output of the stored procedure when i execute using Run Command in plsql developer. But my question is how to do it using EXECUTE COMMAND. I tried to do like the below code but getting error. Can you please help me to resolve this. Let me know in case of any other way also
I tried the below code to achieve
--------------------------------------------------------
var cur3 refcursor;
execute pkg_name.spCylockCustomerApplicationPrivilege('1'.'1', :cur3);
print cur3;
-------------------------------------------------------
(Cursor Name is cur3
Input Parameters I have passed value as 1, 1)
Thanks in Advance