Use the Deploy PL/SQL Packages wizard to
deploy PL/SQL packages in a project.
Before you begin
Create the PL/SQL package.
Procedure
To deploy a PL/SQL package:
- Right-click one or more supported PL/SQL packages or the
PL/SQL folder in the Data Project Explorer, and click Deploy from
the pop-up menu. A wizard opens.
- Complete the steps of the wizard. Some of the
fields in the wizard are populated based on the default settings that
are specified in the Deploy options preferences pages, and some of
the fields are populated with the values from the packages that you
want to deploy. If you select to deploy to a different server, you
can select an existing database connection or create a new connection.
Connections to supported database servers are the only connections
that are available in the list of existing connections.
- Click Finish.
Results
The deploy process begins, and you can view the progress and
messages in the SQL Results view.
What to do next
You can now run the PL/SQL package, and use the Routine
debugger. You can also edit PL/SQL packages that are deployed in a
database. After updating the package, you can replace the package
that is on the database with the updated package.