Discussion :

[tifou31]

salut,
j'ai un souci avec mon trigger (je debute ...)il n'y a pas d'erreurs lors de la compilation mais quand je fais un update voici l'erreur :

ERROR at line 1:
ORA-04091: table SIMSAVE.APPLET_INFO is mutating, trigger/function may not see
it
ORA-06512: at "SIMSAVE.TRIG2", line 3
ORA-04088: error during execution of trigger 'SIMSAVE.TRIG2'


voici mon trigger

create or replace TRIGGER trig2
AFTER update ON APPLET_INFO
REFERENCING NEW AS newRow
FOR EACH ROW
BEGIN

INSERT INTO MODIF VALUES(:newRow.IMEI,(select c.msisdn from applet_info a , account c where a.account_id = c.account_id and a.imei = :newRow.imei));
END trig2;



merci d'avance

[Chtulus]

Bonjour,

10 secondes dans les tutaux et hop !!!

[tifou31]

merci !!