Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Execute Stored Procedure in plsql Developer

VSatNov 2 2020 — edited Nov 2 2020

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

Comments
Post Details
Added on Nov 2 2020
2 comments
4,614 views