Oracle - Problemas con un Triger

 
Vista:

Problemas con un Triger

Publicado por Tipitipi (30 intervenciones) el 12/12/2007 23:35:20
Hola a todos:

Tengo problemas con el siguiente triger:

CREATE OR REPLACE TRIGGER "SYSTEM"."TTY" AFTER
INSERT ON "PERSONAL" BEGIN
insert into system.personal values ( 'Pepito' );
END;

El problema que me devuelve la consola cuando realizo un "insert" es el siguiente:

SQL> insert into system.personal values ('Marcos');
insert into system.personal values ('Marcos')
*
ERROR en lÝnea 1:
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-06512: at "SYSTEM.TTY", line 2
ORA-04088: error during execution of trigger 'SYSTEM.TTY'
ORA-06512: at "SYSTEM.TTY", line 2
ORA-04088: error during execution of trigger 'SYSTEM.TTY'
ORA-06512: at "SYSTEM.TTY", line 2
ORA-04088: error during execution of trigger 'SYSTEM.TTY'
ORA-06512: at "SYSTEM.TTY", line 2
ORA-04088: error during execution of trigger 'SYSTEM.TTY'
ORA-06512: at "SYSTEM.TTY", line 2
ORA-04088: error during execution of trigger 'SYSTEM.TTY'
ORA-06512: at "SYSTEM.TTY", line 2
ORA-04088: error during execution of trigger 'SYSTEM.TTY'
ORA-06512: at "SYSTEM.TTY", line 2
ORA-04088: error during execution of trigger 'SYSTEM.TTY'
ORA-06512: at "SYSTEM.TTY", line 2
ORA-04088: error during execution of trigger 'SYSTEM.TTY'
ORA-06512: at "SYSTEM.TTY", line 2
ORA-04088: error during execution of trigger 'SYSTEM.TTY'
ORA-06512: at "SYSTEM.TTY", line 2
ORA-04088: error during execution of trigger 'SYSTEM.TTY'
ORA-06512: at "SYSTEM.TTY", l

pero si en vez de disparar el triger con un insert,lo disparo con un "Update", funciona correctamente.

Alguien sabe por qué ?

Muchas Gracias y Saludos
Valora esta pregunta
Me gusta: Está pregunta es útil y esta claraNo me gusta: Está pregunta no esta clara o no es útil
0
Responder