Validating PL/SQL packages

Use the Validate action to ensure that the PL/SQL package is valid before deploying it.

Procedure

To deploy a PL/SQL routine to a database:

  1. Right-click one or more supported data objects or the Routines folder in the Data Project Explorer or Data Source 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 routines 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. After the package is deployed, you can refresh the Data Source Explorer view to verify that the package was added to the server.

Feedback