Note: The INSERT INTO… code is not valid until you enter column values.
You can use the Debugger to check for dependencies, and compile them.
To compile dependencies manually
Click or its drop-down on the debug toolbar and select the appropriate option.
Toad can automatically compile any procedures that call the current procedure.
To set options to handle dependent objects
See Debugger Options in the online help for more information.
You can visually view dependencies and their status.
To view dependencies and references
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:
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.
If you are debugging a long procedure, you can stop the debugger while it is working.
To stop the Debugger while it is debugging
The status panel will reset from Running to Idle.