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
Thanks once again
GTDG
October 14, 2013, 5:50am
4
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
Toad for Oracle - Discussion Forum
Flag
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?
Mine conf is Toad 12.1.0.22 x64
Brg
Damir
GTDG
October 14, 2013, 6:15am
6
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
Toad for Oracle - Discussion Forum
Flag
Hello,
And What about, when one of the parameter is a CLOB, how can you initialize ?
Thks. So much.
[mention:130fc847a7304630ba043b4fa3b9ec3e:e9ed411860ed4f2ba0265705b8793d05]
