Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Edmonton Alberta Canada
    Posts
    41

    Unanswered: updating the same table in a update trigger

    Is it possible? I have been able to solve the mutating table error with creating package tables. But it seems that my update query inside of the update trigger will call the trigger again, like recursively. Is there anyway for me to do disable trigger before the update, then enable it again after the update inside of the update trigger?

    Currently I am getting
    ORA-00036: maximum number of recursive sql levels num exceeded.

    Thanks!

    -mongo

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

    Re: updating the same table in a update trigger

    You could use a package variable to do this in the trigger:
    PHP Code:
    if pkg.in_trig then
      
    -- Do nothing
      null
    ;
    else
      
    pkg.in_trig := true;
      
    update table...;
      
    pkg.in_trif := false;
    end if; 

Posting Permissions

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