Execute a Oracle procedure using Toad

exec-procedure.sql

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.