Importing routine templates

In addition to adding new templates by using the New Template window, you can import existing routine templates through the Preferences window.

Before you begin

Before you can import a routine template, you must export a routine template to the file system. The XML file format that is created by the export is the only format that the import recognizes.

About this task

You can import into your workbench routine templates that members of your team create in their workbench and then export.

Procedure

To import a routine template:

  1. Select Window > Preferences.
  2. In the Preferences window, select Data Management > SQL Development > Routines > Templates.
  3. On the Templates page, click Import, and then browse to and select the file that contains the template that you want to import. The template in the imported template file is added to the list of templates on the page.
  4. Click OK in the Preferences window.

Results

The imported template is available in your workbench for you to use in the routine creation wizards.

Feedback