Set Parameters in Triggers
Note: The INSERT INTO… code is not valid until you enter column values.
Handle Dependencies
You can use the Debugger to check for dependencies, and compile them.
Manually compiling dependent & referenced objects
To compile dependencies manually
Click 
or its drop-down on the debug toolbar and select the appropriate option.
Automatically Compiling Dependent Objects
Toad can automatically compile any procedures that call the current procedure.
To set options to handle dependent objects
- From the View menu, select Options.
- In the left pane, select Debugger | General.
- In the Compile Dependencies area, select one of the following:
- Yes - Toad will always compile dependencies.
- No - Toad will never compile dependencies.
- Prompt - Toad will check for dependencies and ask if you want to compile them.
See Debugger Options in the online help for more information.
Viewing Dependencies and their Status
You can visually view dependencies and their status.
To view dependencies and references
- From the Schema Browser, , click the Procedures, Functions, or Packages tab.
- Select the procedure you are debugging, then in the details pane, click the Deps(uses) and Deps (used by) tabs. Status of the procedure is listed in the Status column in the details pane as valid or invalid.
Call Stack Window
The Call Stack window displays the chain of functions and procedures as they are called, in the order they are called, with the most recent function or procedure listed on the top.
At the end of each procedure name is the current line number in that procedure. So, if you step into procedure B from line 5 of procedure A, then the call stack will look like this:
Procedure B(1)
Procedure A(5)
When using the JDWP Debugger, the Call Stack window displays call stack frames in the left pane and variables in the right pane. The Variables pane allows you to set values: right-click the variable and select Set value.
To access the call stack
From the Desktops area, click the Call Stack tab.
To add the call stack tab to the Desktop
Right-click in the Desktops area and select Desktop Panels | Call Stack.
Stop the Debugger
If you are debugging a long procedure, you can stop the debugger while it is working.
To stop the Debugger while it is debugging
-
Click 
.
The status panel will reset from Running to Idle.
- When you have finished debugging your PL/SQL code, discard the debug symbol table: compile it again by pressing F9.
