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 

	var result refcursor -- create a variable result
	BEGIN
	proc_myActivities('rashidjorvee',:result); -- name of the parameter and all input parameters, and variable result as a last parameter with prefix of colon(:).
	END;
	-- execution of procedure has been completed and result stored in the variable result.
	-- Now you have to print the variable result to see the output.
	print result -- write command print and then variable name to print the result.

view raw exec-procedure.sql hosted with ❤ by GitHub