PL/SQL Packages Window

The PL/SQL Packages window lists the PL/SQL packages that have been instantiated in the currently running modules.

The PL/SQL Packages window has the following elements:

Upward pointing arrow

Click the upward pointing arrow at the top right corner to undock the window from the Debug Console.

Downward pointing arrow

Click the downward pointing arrow at the top right corner to dock the window in the Debug Console.

Pop-up menu commands

Pop-up menu commands (right-click in Windows) are accessible from the colored header (docked window) or the first line below the window title (undocked window). The commands available are:

  • Dock - Docks a floating debug window inside the Debug Console. Command is disabled when a window is docked in the console.
  • Undock - Makes a docked debug window float outside the Debug Console. Command is disabled when a window is floating outside the console.
  • Hide - Closes an opened docked or floating window.

Radio buttons

 

 

 

Options for displaying in the Packages drop-down list.

  • Client - Click this radio button to display local PL/SQL packages.
  • Server - Click this radio button to display stored PL/SQL packages.
  • All - Click this radio button to display both local and stored PL/SQL packages in the Packages drop-down list.

Packages

Drop-down list displays the currently selected PL/SQL package spec or body. Click the drop-down list to choose another instantiated package.

Variable

Package global variable name.

Value

Current value for the package global variable.

If the variable is read-only, the entire cell is highlighted when you try to edit it. If the variable is modifiable, only the value in the cell is highlighted when you select it.

To edit a value, click inside the cell and type a new value. Press the Enter key to set the new value. If you enter an invalid value, a message box appears allowing you to change the value or revert to the original value.



Hide and Show a Debug Window

Hide and Show the Debug Console

Resize a Debug window in the Debug Console

Resize Columns in a Debug Window

Undock and Dock a Debug Window