mutating trigger
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: mutating trigger

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    mutating trigger

    create trigger foundry_tech_ins_upd_row
    after insert or update of superblock on aurora.tb_foundry_tech
    for each row
    when (new.superblock = 1 and new.rcctechid is null)
    begin
    update tb_foundry_tech set rcctechid = 1943;
    end;



    getting error below, How to resolve this


    ORA-04091: table TB_FOUNDRY_TECH is mutating, trigger/function may not see it
    J Gangadhar

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,459

    Exclamation

    Change:
    Code:
    update tb_foundry_tech set rcctechid = 1943;
    To this:
    Code:
    :new.rcctechid = 1943;
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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