Toad World® Forums

Compile with Debug not working as expected in 12.0.1.2


#1

I’m not sure why but when I right click on a package and left on compile, it appears to compile correctly.

However the icon for the package appears as a ‘Valid Object Compiled Without Debug’ instead of the ‘Package - Spec and Body Compiled with Debug’.

I have checked the settings that the 'Default to “Compile with Debug” ’ is ticked.

Can anyone help here?

Thanks.


#2

I tried that and it seems to be working fine for me.

If you turn on spool SQL (Main Menu -> Database -> Spool SQL -> Spool to Screen), you can see what Toad is doing.

Are we compiling with debug?

You should see something like this…

ALTER PACKAGE “SCHEMA”.“PACKAGE” COMPILE DEBUG SPECIFICATION

Possibly followed by a query and then

ALTER PACKAGE " SCHEMA"." PACKAGE" COMPILE DEBUG BODY

Followed by more queries.

You might also want to go into the SB-packages filter and make sure that the “Skip check for debug info” is not checked. If it is checked, that would explain
it. This check is optional because it is sometimes slow.

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

Sent: Friday, August 16, 2013 5:30 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Compile with Debug not working as expected in 12.0.1.2

Compile with Debug not working as expected in 12.0.1.2

Thread created by gwoods

I’m not sure why but when I right click on a package and left on compile, it appears to compile correctly.

However the icon for the package appears as a ‘Valid Object Compiled Without Debug’ instead of the ‘Package - Spec and Body Compiled with Debug’.

I have checked the settings that the 'Default to “Compile with Debug” ’ is ticked.

Can anyone help here?

Thanks.

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.


#3

Hi John,

I ran the Spool SQL option and indeed it does NOT have the DEBUG between COMPILE SPECIFICATION or COMPILE BODY.

I also checked the SB packages filter and “Skip check for debug info” is not checked.


#4

Does anybody have any other options here as this is still not working for me for some reason.

Thanks…


#5

This blog might help:

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/04/10/help-toad-for-oracle-pl-sql-debugger-not-working.aspx

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

Sent: Friday, August 23, 2013 5:14 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Compile with Debug not working as expected in 12.0.1.2

RE: Compile with Debug not working as expected
in 12.0.1.2

Reply by gwoods

Does anybody have any other options here as this is still not working for me for some reason.

Thanks…

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.


#6

Is the debug icon on your main toolbar in the “down” position?

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

Sent: Friday, August 23, 2013 5:14 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Compile with Debug not working as expected in 12.0.1.2

RE: Compile with Debug not working as expected
in 12.0.1.2

Reply by gwoods

Does anybody have any other options here as this is still not working for me for some reason.

Thanks…

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.


#7

Hmm, my image came out really tiny. I’m trying again.


#8

I was able to resize the image – looks to me like the grants issue I emailed a response already and sent link on the blog explaining ….

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Friday, August 23, 2013 8:15 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Compile with Debug not working as expected in 12.0.1.2

RE: Compile with Debug not working as expected
in 12.0.1.2

Reply by John Dorlon

Hmm, my image came out really tiny. I’m trying again.

Attachments:

debug.jpg

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.


#9

OK. If so, then the icon I circled in my screenshot will be disabled for him.

From: Bert Scalzo [mailto:bounce-Bert_Scalzo@toadworld.com]

Sent: Friday, August 23, 2013 8:40 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Compile with Debug not working as expected in 12.0.1.2

RE: Compile with Debug not working as expected
in 12.0.1.2

Reply by Bert Scalzo

I was able to resize the image – looks to me like the grants issue I emailed a response already and sent link on the blog explaining ….

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Friday, August 23, 2013 8:15 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Compile with Debug not working as expected in 12.0.1.2

RE:
Compile with Debug not working as expected in 12.0.1.2

Reply by John Dorlon

Hmm, my image came out really tiny. I’m trying again.

Attachments:

debug.jpg

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.

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.


#10

It was not greyed out – just appeared inactive (i.e. pressing it did nothing). So maybe not the grants issue. Please confirm that schema was granted debug session
so we can eliminate that as possible issue.

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Friday, August 23, 2013 8:49 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Compile with Debug not working as expected in 12.0.1.2

RE: Compile with Debug not working as expected
in 12.0.1.2

Reply by John Dorlon

OK. If so, then the icon I circled in my screenshot will be disabled for him.

From: Bert Scalzo [mailto:bounce-Bert_Scalzo@toadworld.com]

Sent: Friday, August 23, 2013 8:40 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Compile with Debug not working as expected in 12.0.1.2

RE:
Compile with Debug not working as expected in 12.0.1.2

Reply by Bert Scalzo

I was able to resize the image – looks to me like the grants issue I emailed a response already and sent link on the blog explaining ….

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Friday, August 23, 2013 8:15 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Compile with Debug not working as expected in 12.0.1.2

RE:
Compile with Debug not working as expected in 12.0.1.2

Reply by John Dorlon

Hmm, my image came out really tiny. I’m trying again.

Attachments:

debug.jpg

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.

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.

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.


#11

Hi John / Bert,

I contacted one of our DBA’s and he confirmed that the DEBUG CONNECT SESSION is not assigned on our production server which is where I was trying to run this.

Apparently it can be potentially resource intensive which he doesn’t we should be doing on the production server.

Although not the answer I was hoping for it is certainly the answer as to why I can’t get it to work. Certainly not a TOAD issue.

Thanks again guys.


#12

Thanks for the follow-up. It always good to know what happened.

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

Sent: Monday, August 26, 2013 6:11 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Compile with Debug not working as expected in 12.0.1.2

RE: Compile with Debug not working as expected
in 12.0.1.2

Reply by gwoods

Hi John / Bert,

I contacted one of our DBA’s and he confirmed that the DEBUG CONNECT SESSION is not assigned on our production server which is where I was trying to run this.

Apparently it can be potentially resource intensive which he doesn’t we should be doing on the production server.

Although not the answer I was hoping for it is certainly the answer as to why I can’t get it to work. Certainly not a TOAD issue.

Thanks again guys.

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.


#13

Just get into the same problem,

i gave the user grant debug any procedure and debug connect session in the Dev environnement, but still the button is grayed out.

Please let’s know if it is a bug of Toad 12,


#14

I have debug successfully in Toad 12 without any problems (not against Oracle 12.x database, but only 11.x ones).

Here is small info what I always do (when debug is in question):

1.) Grant select on dba_source to whatever role (user doesn’t need to be granted select any dictionary)
2.) Grant debug on individual package or grant debug all procedures to whatever role
2.) Ensure the following is checked Tools -> Preferences -> Oracle -> Options -> Use DBA Views when available

maybe this helps


#15

To compile instrumented code using the command line. Set a conditional compiler-switch on the command line. The compiler will include trace or debug code in the executable.