OraFAQ Forum: Client Tools » how to run a PL/SQL program in Toad

Home » Other » Client Tools » how to run a PL/SQL program in Toad

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to run a PL/SQL program in Toad [message #185995]

Fri, 04 August 2006 13:08

dhanisetti
Messages: 7
Registered: July 2006

Junior Member

Hi Friends,

Please let me know how to run a PL/SQL program in Toad.

Thanks in advance
Dhani

Report message to a moderator

Re: how to run a PL/SQL program in Toad [message #186005 is a reply to message #185995]

Fri, 04 August 2006 13:30

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

There are several ways:

1) Highlight the procedure/function/package in the Schema Browser and then click the Execute Procedure button (lightning bolt icon) or right-click and select Execute Procedure.

2) In the SQL Editor, you can execute an anonymous block by:

begin
  my_procedure_name;
end;

and hitting F9.

Report message to a moderator

Previous Topic:	printing spaces before text in sqlplus editor
Next Topic:	Debugging Procedure with Toad

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 27 20:10:56 CST 2025