You can import non-PL/SQL routines
to a data development project by using a wizard or by dragging and
dropping or copying and pasting a routine from the Data Source Explorer
or from another data development project. Use the Import a Routine
wizard to import stored procedures or user-defined functions to your
data development project. You can import routines from another data
development project, or you can import routines from the local file
system.
About this task
To import a non-PL/SQL routine to a project:
- Switch to the Data perspective.
- Import routine using one of the following methods:
- In the Data Project Explorer, right-click either the Stored
Procedures or User-Defined Functions folder
under a data development project, and click Import from
the pop-up menu. Complete the steps of the Import a Routine wizard.
- Drag and drop a routine to a data development project from
either the Stored Procedures or User-Defined
Functions folder under a database connection in the Data
Source Explorer or from another data development project. You can
only drag and drop routines that are supported for development.
- Copy and paste a routine from the Data Source Explorer or
from a data development or data design project.
Results
The routine is imported to the project in the appropriate
folder.