Toad World® Forums

Compile package with debug that have no paramaters

Hi

Apologies if this is very simple to answer/borderline stupid. I’m trying to debug a package I’m writing and I can never compile with debug. When I go to execute the package the execute button is always greyed out.

I have 4 functions and a procedure in the package, none of them pass any parameters as they are working with the current date and then going through a series of logic for financial billing.

What am I doing wrong here or is this the correct behaviour?

And how would be best to go about debugging the functions + procedures in the package?

[:)]

Compiling and executing are different. Compile is the button highlighted on the left, execute highlighted on the right. Which is disabled?

If execute is disabled then it could be for any number of reasons, most too obscure to list here.

Is your package body loaded? If so, is the package body tab active? You can’t debug from the specification tab, must be the body tab IIRC.

Do you have the right privileges? Go to Help|Toad Advisor. Do you see a message like the one shown below? If so, your schema lacks the DEBUG CONNECT
SESSION and DEBUG ANY PROCEDURE privileges or DEBUG and EXECUTE privs on the object. See the requirements in the
Oracle docs.

From: Jonny1 [mailto:bounce-Jonny1@toadworld.com]

Sent: Thursday, January 15, 2015 2:39 PM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Compile package with debug that have no paramaters

Compile package with debug that have no paramaters

Thread created by Jonny1

Hi

Apologies if this is very simple to answer/borderline stupid. I’m trying to debug a package I’m writing and I can never compile with debug. When I go to execute the package the execute button
is always greyed out.

I have 4 functions and a procedure in the package, none of them pass any parameters as they are working with the current date and then going through a series of logic for financial billing.

What am I doing wrong here or is this the correct behaviour?

And how would be best to go about debugging the functions + procedures in the package?

Smile

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.

4478.1.jpeg

My button on the left compiles. Although I notice only the spec is compiled with debug. The button on the right (lightening) execute with pl sql debugger loads teh page to execute. But it’s execute button is always greyed out.

When you compile the package make sure the compile with debug button is pressed on Toad’s main toolbar.

The dialog that pops up when you execute is the “Set Parameters” window and its execute button is only disabled when there is no package function/procedure selected
to debug. You must select one as seen in this screenshot. If you don’t have anything listed on the left then your procedures are private to the package body. You can only debug those that are surfaced in the spec.

From: Jonny1 [mailto:bounce-Jonny1@toadworld.com]

Sent: Thursday, January 15, 2015 3:05 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Compile package with debug that have no paramaters

RE: Compile package with debug that have no paramaters

Reply by Jonny1

My button on the left compiles. Although I notice only the spec is compiled with debug. The button on the right (lightening) execute with pl sql debugger loads teh page to execute. But it’s execute
button is always greyed out.

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.

http://04j0.mjt.lu/o/04j0/af1ed7d5/g45p1rme.gif