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.
About this task
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:
- Switch to the Data perspective.
- 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.
- Complete the steps of the wizard.
Results
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.