Avoiding the Mutating on trigger

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 Wed, 25 Nov 2009 12:33 pm

I noticed that the link referenced there is broken, please read the explanation why you can't do this kind of reading in the table here: http://www.oracle.com/technology/oramag ... sktom.html and here's how to fix here: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P 11_QUESTION_ID: 290416059674
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

Poston Wed, 25 Nov 2009 1:58 pm

Hi guys Conseguiiiiiiii I created two variables in the Package and food in before the TABELA_1 ....

Thank you Debby:)
debby_acacio
Location: Salvador - BA

Poston Thu, 26 Nov 2009 12:48 pm

It's like I said earlier: If two users run your transaction at the same time, it will give Dick, package variable has no read or write isolation.

Work doesn't mean it is correct.

Hug, Francisco.
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

Poston Thu, 26 Nov 2009 12:50 pm

Have you tested update multiple rows at once? The package will overwrite the values of a row on the other.
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

Poston Wed, 21 Aug 2013 11:09 am

dr_gori I'vê been following the discussion of the topic and come up with an idea. And if I declare the Pragma Autonomous_Transaction on trigger to create a separate transaction and in the end give the commit "; "?
Thyago Oliveira


  • See also
    Replies
    Views
    Last Post