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

Modifying the CLEAR_ALL and EXIT Commands

Oracle Forms's default form menu provides a Clear All command on the Action menu that allows end users to roll back changes in a form. By default, the Clear All item is functionally equivalent to executing the CLEAR_FORM procedure with default parameters:

CLEAR_FORM(ask_commit, to_savepoint);

Similarly, the Exit item on the Action menu is functionally equivalent to calling the EXIT_FORM procedure with default parameters:

EXIT_FORM(ask_commit, to_savepoint);

Since these menu items map directly to key commands, you can change their functionality by writing an appropriate Key trigger. For example, you might want to change the default behavior of the Clear All menu item to roll back all changes in the session, including changes posted in calling forms. To do so, you could write the following Key-CLRFRM ("clear-form") trigger to cause a full rollback:

CLEAR_FORM(no_commit, full_rollback);

Similarly, you can change the rollback mode for the Exit menu item to NO_ROLLBACK, so that changes posted in the current form are not rolled back on exit. To do so, write the following Key-Exit trigger:

EXIT_FORM(ask_commit, no_rollback);


About the default form menu