<< 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


Package bodies





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.


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:


Edit in new window

Opens a separate editor window.



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




Drops the current PL/SQL object.



Shows properties of the current PL/SQL object.



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.



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.


Copy to clipboard



Pin to SGA (keep)

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


Unpin from SGA (unkeep)

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


Show DDL

Generates DDL for the selected object to a file



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.