A script-enabled browser is required for this page to function properly.

Using Built-in Constants as Actual Parameters

There are predefined constants that you can use for many Built-in subprograms. Look at the syntax for the EXIT_FORM Built-in procedure shown below. EXIT_FORM has two optional parameters, commit_mode and rollback_mode, that prescribe how Oracle Forms should exit the current form:

Exit_Form(commit_mode, rollback_mode);

The commit_mode and rollback_mode parameters are of type NUMBER. When you call EXIT_FORM, you can use predefined numeric constants for these parameters. Valid constants for the commit_mode parameter include ASK_COMMIT, DO_COMMIT, NO_COMMIT, and NO_VALIDATE. Valid constants for the rollback_mode parameter include NO_ROLLBACK and TO_SAVEPOINT.

Constants for Built-in subprograms are predefined literals that are declared by Oracle Forms as type NUMBER at startup. The actual numeric value of each constant is stored internally, and is not externalized.

When you use constants as actual parameters, enter them exactly as they appear in the syntax, and do not enclose them in quotes:

Exit_Form(DO_COMMIT,NO_ROLLBACK);

Because Built-in constants are of type NUMBER, they can be assigned to NUMBER variables. However, constants cannot appear on the left side of an expression.


Built-ins overview