How to execute a procedure written in Oracle using Toad?
Below is the syntax to execute the stored procedure using Toad for Oracle tool.
Below is the syntax to execute the stored procedure using Toad for Oracle tool.
Syntax:
var <variable_name> refcursor
BEGIN
rocedure_name('<parameter1>','<parameter2>',:<variable_name>);
END;
print <variable_name>
e.g.
var result refcursor
BEGIN
proc_MyProcedure('jorvee',:result);
END;
print result
No comments:
Post a Comment