<< Click to Display Table of Contents >>

Overview PL/SQL Objects

Top Previous Next

Overview PL/SQL Objects is the default sheet. It presents a list of all packages, package bodies, procedures, functions and triggers in the selected schema.

The information contained on this page is classified by the following groups:

PL/SQL object

Status / Timestamps

DB Object Cache (Disabled by default)

PL / SQL Debug

Use the tabs below the data grid to switch between

Packages

Package bodies

Procedures

Functions

Trigger

 

To improve performance, the display of the relevant synonyms can be turned off by clearing the Include Synonyms check box in the upper right corner of the window. Hora saves the option that you choose and remembers it the next time that you use the same database connection.

      IncludeSynonyms

If you have selected the Packages tab and the check box is selected, the display will include both packages in the current schema and all synonyms of packages in the current database. Synonyms can be distinguished from packages by their icon. This applies to the Package Bodies, Procedures, and all other tabs, as well.

 

Synonyms of PL/SQL objects that are outside the current database are not displayed for performance reasons. To see these synonyms, click the Synonyms icon in the Sidebar.

The icons beneath the PL/SQL object name in the first grid column also indicate the PL/SQL object type. Invalid objects are grayed. Objects with errors are displayed in red.

 

The following context operations are available:

147_EditInNewWindow

Edit in new window

Opens a separate editor window.

 

Create

Creates a new, empty PL/SQL package, package body, procedure or function (depending on the tab selected from the bottom) from a template. You will be prompted to enter a name and the source code.

 

Create Wrapped

 

07_Drop

Drop

Drops the current PL/SQL object.

05_Properties

Properties

Shows properties of the current PL/SQL object.

 

Replace

Replaces the source code with the contents of the source code editor. This menu item is only enabled if the source code page is active too.

PackagesCompile

Compile

Compiles the current PL/SQL object.

 

Compile Debug

Compiles the current PL/SQL object with debugging information. This enables PL/SQL Debugger to evaluate and modify values of local variables when the Debugger has stopped within the PL/SQL object.

CopyToClipboard

Copy to clipboard

 

ProcPin

Pin to SGA (keep)

Pins the current PL/SQL object to the SGA. It will always be kept in memory.

ProcUnpin

Unpin from SGA (unkeep)

Unpins the current PL/SQL object from the SGA. Now it can be swapped out of memory.

SHOWDDL

Show DDL

Generates DDL for the selected object to a file

 

Search

Searches for a string within all PL/SQL objects of the current schema. You can see a list of all hits.

 

Grid View

For more information, see object window

 

The Overview shows the status of the object (valid or invalid), and the creation and last DDL timestamps.

It also shows statistics about the object's status in the SGA, taken from the V$DB_OBJECT_CACHE view. For objects that have been swapped out of memory, this information may be populated by compiling the object from the context menu.