Menu

Execute Oracle procedure using Toad

How to execute a procedure written in Oracle using Toad?

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