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:
- In the Data Project Explorer, double-click a PL/SQL package. The PL/SQL Package editor opens.
- 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.
- Click to save your changes.
Results
The properties or source code of the PL/SQL package are changed.