Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    6

    Question Unanswered: Triggers and COMMIT/ROLLBACK

    I need a trigger to be fired or a stored procedure to be called on an event of COMMIT or ROLLBACK.

    Non of ORACLE, SQL-SERVER, DB2 have this feature.

    Please let me know any alternative's

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    I think that every time that occurs a COMMIT or ROLLBACK you can question with record SQLCA.SQLCODE or STATUS, then call one SPL.
    But you need touch of programs.

    Gustavo.

Posting Permissions

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