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

PL/SQL Editor Context

The Type and Object options at the top of the PL/SQL Editor define the current object context. The Name option lists all of the code objects defined in that context.

When you invoke the PL/SQL Editor, if the currently selected object is a code object or an object with which code objects are associated, the PL/SQL Editor is synchronized to that object's context. If there is a code object defined in the current context, it is displayed in the PL/SQL Editor. If no code objects are defined, you will be prompted to select a trigger name or for a program unit name to create.

You can change the Type, Object, and Name options when you want to view code objects defined in a different context.

Type
 
Sets editor context to a specific type of code object. When the current module is a form, Type can be set to Trigger or Program Unit. When the current module is a menu, Type can be set to Menu Startup Code, Menu Item Code, or Program Unit. When the current module is a library, Type is always Program Unit.
 
Object
 
Sets editor context to a specific object scope. When Type is set to Trigger, object scope can be set to form by selecting Form Level in the first poplist. To set editor context to a particular block, select the name of the block in the first Object poplist. To set editor context to an item, select the block that contains the item in the first Object poplist, then select the item itself in the second poplist.

When the current module is a menu, you can edit menu item PL/SQL commands by setting Type to Menu Item Code, then selecting the menu on which the item appears in the first object Object poplist, and the menu item itself in the second poplist.
 
Name
 
The Name option lists all of the code objects defined in the current context. Selecting a code object from the Name poplist makes that object the current object in the editor. For example, when context is set to item-level trigger, the Name poplist shows all of the triggers attached to that item. To display a particular trigger, select it from the Name poplist.

When editor context is set to Program Unit, the Name poplist shows all subprograms and packages defined in the current module.