The TO_SAVEPOINT, NO_ROLLBACK, and FULL_ROLLBACK parameters are predefined numeric constants, and should be entered without single quotes, as shown in the following examples:
CLEAR_FORM(ask_commit, to_savepoint);
NEW_FORM('my_form', no_rollback);
EXIT_FORM(ask_commit, full_rollback);
Rollback Parameter |
Description |
---|---|
TO_SAVEPOINT |
The default. Oracle Forms rolls back uncommitted changes (including posted changes) to the last savepoint. If the form is a called form, any changes that were posted in the calling form are preserved. But changes in the current form or locks acquired are lost. |
NO_ROLLBACK |
Oracle Forms does not issue a rollback, and posted changes are preserved. (Unposted changes in the current form are lost.) When calling a new form or exiting a called form, any locks that were obtained by the current form remain in effect. |
FULL_ROLLBACK |
Oracle Forms rolls back all uncommitted changes pending in the current session (including posted changes). This includes changes made in the current form, posted changes made in forms that called the current form, and posted changes made in forms that were called by the current form. |
Note that full rollbacks are not allowed when a form is in post-only mode, and calling a procedure with the FULL_ROLLBACK parameter returns an error such as:
FRM-40739: Clear_Form with FULL_ROLLBACK not allowed in post-only form.