Sunday, January 06, 2008

Commit, commit_form and forms_ddl

commit
this is db command (only), not FORMS and if:

  • form has upPOSTed statements they may be ignored
  • form not fire PRE, POST, ON - commit triggers
commit execute as client side statement


forms_ddl(commit)
this is dynamic sql - commit and commit execute as server side. And form doesn't know about commit. it commits the all the DML transactions if any executed and pendig for commit .

commit_form
  • It fires commit for all the database blocks on the form
  • it commits the all the DML transactions if any executed and pendig for commit .

0 comments: