A script-enabled browser is required for this page to function properly.

Setting a debug trigger

To set a debug trigger:

    If the PL/SQL Interpreter is not already displayed, choose Toolsright arrowPL/SQL Interpreter.

    In the Object Navigator, single-click a compiled program unit node to display the program unit in the Interpreter source pane.   Note: Uncompiled program units are indicated by an asterisk (*) after their name.

    In the Source pane, select the line where you want to create the debug trigger, then choose Programright arrowDebugging Triggers (or right-click in the Source pane and choose Trigger).

    Tip:   You cannot place a debug trigger on a BEGIN, END, or NULL statement, or on a comment.

  1. In the PL/SQL Trigger dialog box, define the trigger:

    Note: To create a debug trigger that contains multiple lines of text, include a BEGIN and an END statement around the code.

    You must raise the DEBUG.SUSPEND exception from the DEBUG package if you want the PL/SQL Interpreter to appear when this line is executed. Otherwise, Reports Builder executes the code silently and the PL/SQL Interpreter does not appear.

  2. Click OK to create a debug trigger for the selected line.

Tip: You can also create a debug trigger by entering commands in the PL/SQL Interpreter pane.

See also

About the PL/SQL Interpreter

About debug commands in the PL/SQL Interpreter