Debugging PLSQL in Toad

plsql toad
aggietech picture aggietech · Sep 18, 2012 · Viewed 48.9k times · Source

I've been creating packages for Oracle db using PL/SQL and i'm trying to find a good way to debug a PL/SQL package without using the "put_line" command, does anyone have some good tips on how to successfully debug a PL/SQL package either on Toad or SQLPlus?

Answer

wweicker picture wweicker · Oct 5, 2012

Depending on the version of TOAD, the icons and toolbars will look different, but the process is the same:

  1. Make sure the "Toggle compiling with Debug" option is turned on
  2. Click "Compile" button
      a. Set a breakpoint
  3. Click "Execute PLSQL with debugger"

Toad 9.7:

TOAD 9.7

Toad 11.6:

TOAD 11.6

Related questions

Simple Oracle variable SQL Assignment

Despite having spent an hour researching I can't seem to figure out how to correctly define a variable and then use it in your SQL. This is what I have so far produced: DECLARE startDate DATE := to_date('03/11/2011', …

Read More
ORA-00932: inconsistent datatypes: expected - got -

I have been using Oracle(10g.2) as a PHP programmer for almost 3 years, but when I gave an assignment, I have tried to use the ref cursors and collection types for the first time. And I 've searched the web, …

Read More
Display results in output parameter in Toad

I have a stored procedure in Oracle and I'm using an out parameter in it.. I want to know how to display the output in Toad..

Read More