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.

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.

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

  1. Click Window > Preferences from the main menu.
  2. Click Data > Stored Procedure and User-Defined Functions to see available options. If you do not see these nodes, click General > Capabilities in the Preferences window and enable the Database Development capability.

Comentarios