Importing non-PL/SQL routines to a project

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:

  1. Switch to the Data perspective.
  2. 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.

Feedback