Exporting non-PL/SQLroutines from a data development project to a script

Use the Export a Routine wizard to export non-PL/SQL stored procedures or user-defined functions from a data development project to a script file on the file system for later deployment. You can also choose to create a ZIP file that includes all associated export files.

The following instructions apply to non-PL/SQL routines that are stored in a data development project.

To export a non-PL/SQL routine to a script:

  1. Switch to the Data perspective.
  2. In the Project Explorer, right-click a non-PL/SQL routine or either the Stored Procedure or User-Defined Functions folder, and click Export from the pop-up menu. The Export a Routine wizard opens.
  3. Complete the steps of the wizard.
The export script is saved in the file system in the directory that you specified in the wizard. In that directory you will also find a file called DeployInstructions.txt that contains instructions that describe how to deploy the script. The export script is either an SQL file or an XML file, depending on the routine type and target database.

Feedback