SQL & PL/SQL

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!

how to execute a stored procedure with an out parameter ?

ManjitSep 22 2003 — edited Sep 22 2003

Guys I am struggling with executing a stored procedure from sql plus.I mean my stored procedure has 2 input parameter and 1 out put parameter (status of the execution).

MY_PROCEDURE(p_name in varchar2,p_age in number,p_status out varchar2)
.
.
.
.
.
end my_procedure;

When I say

EXECUTE MY_PROCEDURE('manohar','Shetty');

i get insufficient parameters errors.

please help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 20 2003

Added on Sep 22 2003

5 comments

636 views