Viewing and editing routines in a PL/SQL package

You can use the PL/SQL Package editor to edit the source code and properties of a routine, such as a stored procedure or user-defined function, in a PL/SQL package.

About this task

If you make source code changes using the PL/SQL Package editor or if you modify the specification or body of a PL/SQL package, you must save and deploy again to the database server to apply the changes to the server version.

Restriction: In the Data Source Explorer, you can view PL/SQL package properties but you cannot change them.

Procedure

To edit the properties or source code of a PL/SQL package:

  1. In the Data Project Explorer, double-click a PL/SQL package. The PL/SQL Package editor opens.
  2. Edit the specification and the body of the PL/SQL package as required.
    Important: The contents of the Specification and the Body pages are not synchronized or validated. If you make changes to the specification or the body contents, you might need to change the other. For example of you change a function name in the specification, change the function name in the body.
  3. Click File > Save to save your changes.

Results

The properties or source code of the PL/SQL package are changed.

Feedback