The General page allows you to define a stored function. This property sheet consists of the following:

Name

Name of the function being defined.

Schema

Name of the schema containing function. The drop-down list contains all schemas available through the database connection.

Compile

Compiles the PL/SQL source for the function so that it can be stored and executed from within the database.

Dates

Created: Date the function was originally created.

Modified: Date the function was last modified.

Status

Current status of the Function (valid or invalid).

Show Errors: Displays the Error Message dialog box listing the errors encountered while trying to compile the function source. This button is only enabled when the function status is invalid. For detailed error message information pertaining to PL/SQL, see Oracle8i Error Messages.

Source

Function SQL statements or PL/SQL constructs.