Trigger

[kkikka]

ESTO ES LO UNICO QUE ME PONE

DOC>*/
1 create trigger INSERTAR_USO_SINTONIA
2 before insert on USO_SINTONIA
3 for each row
4 declare
5 VEXISTE number(1);
6 begin
7 select 1
8 into VEXISTE
9 from SINTONIA
10 where SINTONIA.codigo = :new.USO_SINTONIA;
11
12 exception
13 when no_data_found then
14 insert into SINTONIA(codigo) values (:new.uso_sintonia);
15 end;
16*

Warning: Trigger created with compilation errors.


insert into USO_SINTONIA values ('02-Jan-2005','02-Jan-2006','0009')
*
ERROR at line 1:
ORA-04098: trigger 'INSERTAR_USO_SINTONIA' is invalid and failed re-validation