Sr. X
10 de Abril del 2008

Create or Replace Trigger SIGRADD.Insertar_Peticionario
After Insert
on SIGRADD.PERSONAL
Referencing new as NEW
For each Row
begin
if (:NEW.CCATEGORIA in (\'MG\',\'JS\')) then
insert into SIGRADD.PERSONAL_PETICIONARIOS (CPERSONAL, cpeticionario)
values (:NEW.CPERSONAL, 00001);
end if;

if (:NEW.CCATEGORIA in (\'RA\')) then
insert into SIGRADD.PERSONAL_PETICIONARIOS (CPERSONAL, cpeticionario)
values (:NEW.CPERSONAL, 000228);
end if;
end;Create or Replace Trigger SIGRADD.Insertar_Peticionario
After Insert
on SIGRADD.PERSONAL
Referencing new as NEW
For each Row
begin
if (:NEW.CCATEGORIA in (\'MG\',\'JS\')) then
insert into SIGRADD.PERSONAL_PETICIONARIOS (CPERSONAL, cpeticionario)
values (:NEW.CPERSONAL, 00001);
end if;

if (:NEW.CCATEGORIA in (\'RA\')) then
insert into SIGRADD.PERSONAL_PETICIONARIOS (CPERSONAL, cpeticionario)
values (:NEW.CPERSONAL, 000228);
end if;
end;