COMMIT_FORM and COMMIT do the same thing, they apply any outstanding changes in the form to the DB and issue a DB-COMMIT.
DO_KEY('commit_form') executes the code which is written in your KEY-COMMIT trigger. If that trigger doesn't exist it does the same as COMMIT_FORM.
Oracle Application Developer Guide says:
DO_KEY('commit_form') executes the code which is written in your KEY-COMMIT trigger. If that trigger doesn't exist it does the same as COMMIT_FORM.
Oracle Application Developer Guide says:
Replace COMMIT with do_key('commit_form'), This routine raises the exception FORM_TRIGGER_FAILURE if there is an invalid record.
Sequence of Trigger Fire while Committing
- KEY-Commit
- Pre-Commit
- Pre/On/Post Delete
- Pre/On/Post Update
- Pre/On/Post Insert
- On-Commit
- Post Database Commit