The PL/SQL Editor enables you to create and edit PL/SQL program units.
You can display the PL/SQL Editor in these ways:
Choose ToolsPL/SQL
Editor.
In the Object Navigator, double-click a PL/SQL node icon next to a program unit.
When you make changes to a program unit, dependent program units lose their compiled status. An uncompiled program unit is indicated by an asterisk (*) after its name under the Program Units node in the Object Navigator. You can navigate to those program units directly in the PL/SQL Editor using the Name list to recompile them.
If you delete a PL/SQL package, function, or procedure, you must also delete all references to it in your report. Otherwise, you will get an error when you compile, generate, or run the report.
PL/SQL package, function, and procedure names must be unique within the report and may not duplicate the names of any columns, groups, queries, or printable objects.
PL/SQL Editor (context-sensitive help topic)
About the Stored PL/SQL Editor
Copyright © 1984, 2005, Oracle. All rights reserved.