Home » SQL & PL/SQL » Client Tools » how to run a PL/SQL program in Toad
how to run a PL/SQL program in Toad [message #185995] Fri, 04 August 2006 13:08 Go to next message
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
Re: how to run a PL/SQL program in Toad [message #186005 is a reply to message #185995] Fri, 04 August 2006 13:30 Go to previous message
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.
Previous Topic: printing spaces before text in sqlplus editor
Next Topic: Debugging Procedure with Toad
Goto Forum:
  


Current Time: Sun Dec 11 02:29:58 CST 2016

Total time taken to generate the page: 0.08193 seconds