Toad World® Forums

An easy way to execute a single Stored Procedure from a Package with 100s

Hi Guys

At work we have packages that house many, many stored procedures. How can I execute a single stored procedure from within toad?

What I currently do is copy the stored procedure that I want, take it into another editor window, and run it that way, but surely there is an easier way no?

When I right-click on the specific procedure within the package, I don’t get an option to execute that procedure along, instead I get the option to execute all stored procedures within the package!

Any help would be greatly appreciated.

Thank You.

AFAIK, only procedures can be called from the package. Indeed, after you choose Execute package, you get window like:

So answer on your ask is yes you can run procedures only directly from the packages.

Brg

Damir

Thanks Damir

I did not know that another window will pop-up after wards asking me exactly which procedure I want to run :slight_smile:

Thanks once again :slight_smile:

Just a clarification - procedures and functions can be executed, not just procedures.

From: damir.vadas_531 [mailto:bounce-damirvadas_531@toadworld.com]

Sent: Monday, October 14, 2013 8:47 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] An easy way to execute a single Stored Procedure from a Package with 100s

RE: An easy way to execute a single Stored Procedure from a Package with 100s

Reply by damir.vadas_531

AFAIK, only procedures can be called from the package. Indeed, after you choose Execute package, you get window like:

where you can on the left side choose which procedure would you like to run (mark with number 1).

For functions there is no such a possibility.

So answer on your ask is yes you can run procedures only directly from the packages.

Brg

Damir

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Cool. You are right ... [:D]

But ....

Now I see that there are only 4 procedures/functions in the list when package has more then dozen.... Now I ask how to see others procedures/functions?
Is this is parameter (couldn't find it) or what.

Mine conf is Toad 12.1.0.22 x64

Brg

Damir

From: damir.vadas_531 [mailto:bounce-damirvadas_531@toadworld.com]

Sent: Monday, October 14, 2013 9:10 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] An easy way to execute a single Stored Procedure from a Package with 100s

RE: An easy way to execute a single Stored Procedure from a Package with 100s

Reply by damir.vadas_531

Cool.

Can you show me a window with list of fnc/proc and your active popup is function…

THy

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Hello,

And What about, when one of the parameter is a CLOB, how can you initialize ?

Thks. So much.

[mention:130fc847a7304630ba043b4fa3b9ec3e:e9ed411860ed4f2ba0265705b8793d05]