Use the Options page to
view optional settings for the user-defined
function.
- Specific name
- Shows the specific name for the user-defined function, a unique
name
that distinguishes multiple user-defined functions with the same name
and
different parameters. If you do not specify this name, the database
generates
it the first time you build the procedure. You can use the specific
name to
drop or comment on a user-defined function. You can not use the specific
name
to invoke the user-defined function.
- Language
- Shows the language of that the user-defined function is written
in.
- Package
- Shows the package for
the SQL user-defined function.
- Contains
SQL
- Specifies that the user-defined function contains SQL
statements and
does not read nor modify SQL data.
- Deterministic
- Shows whether the user-defined function returns the same result
from successive
calls with identical input parameters. When this check box is not
selected,
the user-defined function might not return the same result from successive
calls with identical input parameters.
- External
action
- When checked, specifies that the function takes some
action that changes
the state of an object that is not managed by the database manager.
External
action must be explicitly or implicitly specified if the body of the
function
calls another function that has an external action.