Home » SQL & PL/SQL » Client Tools » how to exec a procedure within Editor
how to exec a procedure within Editor [message #439247] Fri, 15 January 2010 05:54 Go to next message
pyscho
Messages: 134
Registered: December 2009
Senior Member
How do i do this guys?

something like

exec packagename.procedure ?
Re: how to exec a procedure within Editor [message #439248 is a reply to message #439247] Fri, 15 January 2010 06:01 Go to previous messageGo to next message
cookiemonster
Messages: 12415
Registered: September 2008
Location: Rainy Manchester
Senior Member
Depends what editor you are talking about.
That'll work in sqlplus (since exec is a sqlplus command), probably won't work in TOAD and others.
So what tool are you using?
Re: how to exec a procedure within Editor [message #439249 is a reply to message #439248] Fri, 15 January 2010 06:04 Go to previous messageGo to next message
pyscho
Messages: 134
Registered: December 2009
Senior Member
Sorry for the lack of info. I'm using Toad for Oracle 9.725 and want to manually execute my procedure within the editor
Re: how to exec a procedure within Editor [message #439257 is a reply to message #439247] Fri, 15 January 2010 07:16 Go to previous message
cookiemonster
Messages: 12415
Registered: September 2008
Location: Rainy Manchester
Senior Member
Use an anonymous PL/SQL block
BEGIN
packagename.procedure;
END;
Previous Topic: Toad Schema Browser Multi Tabs
Next Topic: login.sql not working?
Goto Forum:
  


Current Time: Wed Dec 07 18:25:59 CST 2016

Total time taken to generate the page: 0.05991 seconds