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:
- 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.