DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2001
    I want to know what's the difference in commit and forms_ddl(commit) in a trigger written in a form.

    Thanks and Regards,

  2. #2
    Join Date
    Sep 2001
    NJ, USA
    1. commit - this is db command (only), not FORMS and if:
    - form has upPOSTed statments they may be ignore
    - form not fire PRE, POST, ON - commit triggers

    commit execute as client side statment

    PS: some times commit; doesn't execute
    I had case when :
    form A : call_form('B'); -- without POST
    form B : call_form('C'); -- without POST
    form C : commit; -- and commit didn't work
    but if I used forms_ddl(commit) then all direct (in PL/SQL blocks) statments were commited.

    2. forms_ddl(commit) - this is dynamic sql - commit and
    commit execute as server side. And form don't know about commit nothing

    3. commit_form
    - form POST all statments
    - form fire PRE, POST, ON - commit triggers

    [Edited by Shestakov on 10-26-2001 at 05:10 PM]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

By using this site, you agree to the Privacy Policy