Specifying a master routine template

You can create a master template for routines to share among team members, and use the Preferences window to specify the location of the file.

Before you begin

Before you can specify a master routine template, you must create the master template XML file by exporting existing routine templates to the file system. The XML file format that is created by the export is the only format that can be used as a master tempalte.

About this task

You can create and maintain a single template XML file and reuse it among team members. Templates in the master file take priority and will replace any local version of the same named context+template.

Procedure

To specify a master routine template:

  1. Select Window > Preferences.
  2. In the Preferences window, select Data Management > SQL Development > Routines > Templates.
  3. On the Templates page, click New.
  4. In the Master Template section, specify the path to a routine template XML file that was previously exported to the file system. The XML format must exactly follow the format of exported routine templates. For information about specific XML format, see the related topic.
  5. Click OK in the Preferences window.

Results

The master template is now used in the routine creation wizards.

Feedback