Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    New Delhi
    Posts
    4

    Unanswered: Database triggers

    How are the DMLs commited in the database triggers internally as they are based on a table and any table commit will commit all the pending transactions which could lead to problems.

    I want to know the flow or algorithm of implicit commit of dbtriggers.

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Database triggers

    In Oracle, at least, there is no implicit commit of database triggers. Any DML performed within database triggers forms part of the same transaction as the triggering statement, and all is either committed or rolled back together when the user issues an explicit COMMIT or ROLLBACK.

Posting Permissions

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