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.
- Click to see available
options. If you do not see these nodes, click in the Preferences window
and enable the Database Development capability.