Menu

Showing posts with label Execute Oracle procedure using Toad. Show all posts
Showing posts with label Execute Oracle procedure using Toad. Show all posts

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