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.