Deploying PL/SQL packages from a data project to a database

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:

  1. 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.
  2. 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.
  3. 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.


Feedback