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.