Chat now with support
Chat with Support

Toad for Oracle 12.12 - Getting Started Guide

Table of Contents Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

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

  1. From the View menu, select Options.
  2. In the left pane, select Debugger.
  3. 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

  1. From the Schema Browser, objects panel, click the Procedures, Functions, or Packages tab.
  2. 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)

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

  1. Click .

    The status panel will reset from Running to Idle.

  2. When you have finished debugging your PL/SQL code, discard the debug symbol table: compile it again by pressing F9.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating