How to debug a stored procedure in Toad?

Question

I have Oracle 10g installed and there is a package which has a number of cursors and procedures, how do I debug one of these procedures or cursors. Can you please provide steps for that? I ran a Google search but did not find anything specifying how to debug a particular procedure from a package.

Answer 1

Basic Steps to Debug a Procedure in Toad

1. Load your Procedure in Toad Editor.
2. Put debug point on the line where you want to debug.See the first screenshot.
3. Right click on the editor Execute->Execute PLSQL(Debugger).See the second screeshot.
4. A window opens up,you need to select the procedure from the left side and pass parameters for that procedure and then click Execute.See the third screenshot.
5. Now start your debugging check Debug-->Step Over...Add Watch etc.

Reference:Toad Debugger

Answer 2

Open a PL/SQL object in the Editor.

Click on the main toolbar or select Session | Toggle Compiling with Debug. This enables debugging.

Compile the object on the database.

Select one of the following options on the Execute toolbar to begin debugging: Execute PL/SQL with debugger () Step over Step into Run to cursor