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:
- Click Window > Preferences from the main
menu.
- Expand the Data Management node, the SQL
Development node, and the Stored Procedures and User-Defined
Functions node to see available options.