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

Rolling Back Changes

The Built-in procedures EXIT_FORM and NEW_FORM are similar in that both result in Oracle Forms leaving the current form; the difference between them is that while EXIT_FORM merely leaves the current form, NEW_FORM names another form to be loaded in its place. In both cases, Oracle Forms must either preserve or roll back changes that were made in the current form before exiting. In addition to EXIT_FORM and NEW_FORM, a CLEAR_FORM operation also either preserves or rolls back changes.

You can control whether changes in a form are preserved or rolled back when the following operations occur:

Whether changes are preserved or rolled back depends on the rollback mode specified for these operations.

When you call the EXIT_FORM, NEW_FORM, or CLEAR_FORM procedures, the rollback mode is determined by the constant you supply for the rollback_mode parameter: TO_SAVEPOINT, NO_ROLLBACK, or FULL_ROLLBACK.