OraFAQ Forum: Client Tools » how to exec a procedure within Editor

Home » Other » Client Tools » how to exec a procedure within Editor

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

how to exec a procedure within Editor [message #439247]

Fri, 15 January 2010 05:54

pyscho
Messages: 134
Registered: December 2009

Senior Member

How do i do this guys?

something like

exec packagename.procedure ?

Report message to a moderator

Re: how to exec a procedure within Editor [message #439248 is a reply to message #439247]

Fri, 15 January 2010 06:01

cookiemonster
Messages: 13961
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?

Report message to a moderator

Re: how to exec a procedure within Editor [message #439249 is a reply to message #439248]

Fri, 15 January 2010 06:04

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

Report message to a moderator

Re: how to exec a procedure within Editor [message #439257 is a reply to message #439247]

Fri, 15 January 2010 07:16

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

Use an anonymous PL/SQL block

BEGIN
packagename.procedure;
END;

Report message to a moderator

Previous Topic:	Toad Schema Browser Multi Tabs
Next Topic:	login.sql not working?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 06:01:21 CST 2024