Changing default options for stored procedure and UDF development

In the Preferences window, you can set options for stored procedures and user-defined function development.

About this task

When you set default settings for stored procedure and UDF development in the Preferences window, the settings might be used as follows:
  • They can be shown as the defaults in wizards and windows that use them. You can override defaults in a situation where the defaults do not apply.
  • They can affect build behavior in the workbench. For example, in the Process node, you can specify whether to trace errors. In cases like these, the behavior can only be controlled from the Preferences window.

Procedure

To change the default options for stored procedure and user-defined function development:

  1. Click Window > Preferences from the main menu.
  2. Expand the Data Management node, the SQL Development node, and the Stored Procedures and User-Defined Functions node to see available options.

Feedback