Techniques for Calling a Standalone Procedure From SQL*Plus
First of all, Execute the Code that exist in this post >>> Click Here
and now execute this code to know how you can call the stored subprogram from SQL*Plus using the CALL statement or using a BEGIN ... END block :-
and now execute this code to know how you can call the stored subprogram from SQL*Plus using the CALL statement or using a BEGIN ... END block :-
CALL award_bonus(179, 1000);
BEGIN
Award_bonus(179,10000);
END;
/
-- using named notation
BEGIN
Award_bonus(emp_id => 179,bonus => 10000);
END;
/
Posts
0 comments:
Post a Comment