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

About debug commands in the PL/SQL Interpreter

The following commands are available when using the PL/SQL Interpreter:

CREATE

Creates a new library that can be stored in either the file system or the current database.

DELETE

Deletes:

  • libraries that reside in the current database

  • library program units

  • program units

DESCRIBE

Inspects a variable or parameter that is local to the current scope location. The description includes the name, type, and value of the specified local.

EXPORT

Writes the source of one or more program units to a text file.

LIST

Displays the source text for program units, triggers, and debug actions.

LOG Saves a transcript of PL/SQL Interpreter input and output to the specified log file.
RESET Returns control to an outer debug level without continuing execution in the current debug level.
SET Changes the current scope location to a specified frame of the stack. You can specify relative motion from the current stack frame to any other frame, or move to a particular subprogram on the stack. There are several ways to invoke SET:
  • select a frame entry in the Object Navigator

  • enter the SET command in the PL/SQL Interpreter

SHOW Lists the name, type, and value of all variables and parameters at the current scope location.

See also