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:
- 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.
- 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.
- 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.