Error in Trigger-Mutant Table

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Tue, 03 Mar 2009 4:37 pm

Good afternoon guys, I'm changing some triggers but is going on the table error mutant, look what's happening: I'm changing the trigger but the trigger TRI_TABELA1 TRI_TABELA1 is called by the TRIGGUER TRI_TABELA2. Need to do a select on Table2 inside TRI_TABELA1 and when squeegee this select the table error mutant.


Error: path 1-Update Table2-2 TRI_TABELA2-3 TRI_TABELA2 Started doing update in Table1 calling so TRI_TABELA1 4-When TRI_TABELA1 makes a select into table Table2 happens (PAM!!!) error in the mutant (perhaps the trigger cannot find it) Someone knows how to help me, how to explain this or how to fix?
gessimarjunior
Location: Viana-ES

Poston Tue, 03 Mar 2009 4:49 pm

Yes, but first, see if this topic will help you!
viewtopic.php?t=96
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Wed, 04 Mar 2009 2:01 pm

Is exactly what Dr. Gori has posted in that other post.
You have to decide when you do a select on table 2 from the trigger of tab 1, which \"vision\" of table 2 you want to have, if her vision before or after modification. That's because during the modification you can't see it (hence the mutating error).
A method of contour is in the solution of Tom Kyte in another post. Some people do with package and some people use an auxiliary table.
fsitja
Location: Gaúcho no Rio de Janeiro - RJ

"The scars exist to remind us that the past was real"
Campanha: Como fazer uma pergunta e obter uma resposta.
http://tkyte.blogspot.com/2005/06/how-t ... tions.html

OCA & OCP Developer — OCE SQL Expert — OCS Data Warehousing Specialist


  • See also
    Replies
    Views
    Last Post