Update on Trigger table

Dicas do Oracle Forms Builder - Blocos, Itens, LOV, Canvas, Triggers, comandos, PLL, d2kwutil, FMB, Alert, menus, etc
  

Poston Tue, 19 Aug 2008 4:28 pm

I created a trigger XIS in the YYY AFTER INSERT that makes an update herself in a FLEX_QUALQUER field that should stay with the value of the DATA_VENCIMENTO field.

But error is occurring \"Mutant Table\" when performing trigger.

What is the best way to write the column FLEX_QUALQUER with the value of the DATA_VENCIMENTO? Would be better in the Before Insert?

CREATE OR REPLACE TRIGGER XIS AFTER INSERT ON yyy FOR EACH ROW BEGIN UPDATE yyy SET flex_qualquer = To_Char (data_vencimento, ' NEW.: DD/MM/YYYY ') WHERE xis_pay_id =: NEW. xis_pay_id;

END;
suelana
Location: Joinville-SC

Suelana BLU-JLLE

Poston Tue, 19 Aug 2008 6:45 pm

Suelana, good night.

See if this topic helps you: viewtopic.php?t=96 anything, send it to us.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Poston Tue, 19 Aug 2008 6:48 pm

hmmm ... following .... When you create a trigger for a table ... you can't perform any DML operation on the same = D tries to create it with instead of after \"INSTEAD OF\" is not going to work ... If it works ... Let me ai também I want to know:D Thurs
gokden
Location: Ribeirão Preto - SP

Lucas de Souza

OCA Developer
Analista de sistemas


  • See also
    Replies
    Views
    Last Post


    Return to Forms

    Who is online

    Users browsing this forum: Bing [Bot] and 9 guests