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.
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.
The routine is imported to the project in the appropriate
folder.