RE: Debug anonymous block (Toad 10.6.0.42)

Ah, I feared that.

Thanks.

Unfortunately, I don't have (or otherwise need) access to create functions/procedures at this time.



From: [email protected] [mailto:[email protected]] On Behalf Of Gregory Liss
Sent: Thursday, May 03, 2012 9:41 AM
To: [email protected]
Subject: [toad] RE: Debug anonymous block (Toad 10.6.0.42)



Toad doesn't have the ability to debug anonymous blocks. You can only debug stored procedures/functions/packages.

Greg

-----Original Message-----
From: [email protected]<mailto:toad%40yahoogroups.com> [mailto:[email protected]<mailto:toad%40yahoogroups.com>] On Behalf Of Lovelady, Dennis E.
Sent: Thursday, May 03, 2012 09:39 AM
To: [email protected]<mailto:toad%40yahoogroups.com>
Subject: [toad] Debug anonymous block (Toad 10.6.0.42)

I am new to debugging with Toad, though I have been using Toad, Oracle and PL/SQL for years.

Using Toad 10.6.0.42 with no add-ons, I have converted sample loopproc into an anonymous block and saved it as loopproc.prc:

DECLARE

   tmpvar    NUMBER;

   tmpvar2   NUMBER;

   total     NUMBER;

BEGIN

DBMS_DEBUG.SELF_CHECK;

   tmpvar := 0;

   tmpvar2 := 0;

   total := 0;

   FOR lcv IN 1 .. 100 LOOP

      total := 2 * total + 1 - tmpvar2;

      tmpvar2 := tmpvar;

      tmpvar := total;

   END LOOP;

   DBMS_OUTPUT.put_line('Total is ' || total);

END ;

When I try to debug this, I am only able to set a breakpoint at the DECLARE statement. When I press "Trace Into," the proc will stop at the DECLARE, but subsequent use of "Trace Into" runs to completion without stopping.  Is this expected behavior?  What might I be doing wrong?

By the way, I do not see a "Compile with Debug" option on my toolbar, nor under Commands in Customize Toolbar. And I'm not certain of my access to DBMS_DEBUG, but given that the SELF_CHECK line runs without error - and the fact that I can set a breakpoint at DECLARE - and it does seem to break there - I think (?) that is not the issue.

Thanks,

Dennis

<BR>__________________________________________________________

<FONT size=2><BR>

DTCC DISCLAIMER: This email and any files transmitted with it are

confidential and intended solely for the use of the individual or

entity to whom they are addressed. If you have received this email

in error, please notify us immediately and delete the email and any

attachments from your system. The recipient should check this email

and any attachments for the presence of viruses. The company

accepts no liability for any damage caused by any virus transmitted

by this email.</FONT>

------------------------------------

Yahoo! Groups Links



<BR>_____________________________________________________________
<FONT size=2><BR>
DTCC DISCLAIMER: This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error, please notify us immediately and delete the email and any
attachments from your system. The recipient should check this email
and any attachments for the presence of viruses.  The company
accepts no liability for any damage caused by any virus transmitted
by this email.</FONT>