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 


Tryst with Destiny speech, Jawaharlal Nehru, 15 August 1947


At midnight of 15th August 1947, Leader of Indian national congress (INC) and first prime minster of India addressed our nation with this strong, beautiful and mature speech.

Long years ago we made a tryst with destiny, and now the time comes when we shall redeem our pledge, not wholly or in full measure, but very substantially. At the stroke of the midnight hour, when the world sleeps, India will awake to life and freedom. A moment comes, which comes but rarely in history, when we step out from the old to the new, when an age ends, and when the soul of a nation, long suppressed, finds utterance. It is fitting that at this solemn moment, we take the pledge of dedication to the service of India and her people and to the still larger cause of humanity. ”

Tryst with Destiny speech, Jawaharlal Nehru, 15 August 1947

Quit India Movement