Ayuda con Trigger

[yong321]

You shouldn't create a trigger that has the same action in the trigger body as one of your trigger conditions. Here's what I mean:

SQL> create table t (x int);

Table created.

SQL> create or replace trigger t_t before insert on t for each row begin insert into t values (1); end;
2 /

Trigger created.

SQL> insert into t values (1);
insert into t values (1)
*
ERROR at line 1:
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-06512: at "YHUANG.T_T", line 1
ORA-04088: error during execution of trigger 'YHUANG.T_T'
ORA-06512: at "YHUANG.T_T", line 1
ORA-04088: error during execution of trigger 'YHUANG.T_T'
...

What's the error you got when you say "no funciona"?

Yong Huang