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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.