Trigger Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Trigger Problem

  1. #1
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268

    Angry

    Hi,
    I have a complex problem.
    I am trying to update a table in this order:
    after an insert is performed, i fire a trigger that will recalculate sum of columns.
    I keep getting ORA-4091 (Table Mutating ...).
    What do i do ???

    Thanx.

  2. #2
    Join Date
    Feb 2001
    Posts
    180
    Take a look over here:
    [url]http://asktom.oracle.com/pls/ask/f?p=4950:8:19593::NO::F4950_P8_DISPLAYID[/url],F4950_P8_CRITERIA:290416059674,{trigger}.

    Regards
    Ben de Boer

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