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

    Post Unanswered: ORA-04091 Mutating table error

    Hi,

    I'm using an after insert or update trigger(row level) which calls a stored procedure to send a mail using the UTL_SMTP package. But when the trigger fires i get the mutating table error. I am not doing any insert or update or delete operation using the trigger on the database. But the stored procedure does have a couple of queries.
    Can anyone suggest any workaround to this ?

    Thanks in advance.

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

    Re: ORA-04091 Mutating table error

    Tom Kyte explains the standard work around here:

    http://asktom.oracle.com/~tkyte/Mutate/index.html

Posting Permissions

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