You can import 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.
Procedure
To import a non-PL/SQL routine
to a project:
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.