Esli ja meniaiu znachenie proc v tablize al_t_a_f_user,to mne vydetsia oshibka:
Trigger ne dolgen etogo videti.
Podskagite v chem moia oshibka?

CREATE TRIGGER al_tr_proc
AFTER UPDATE OF proc ON al_t_a_f_user
REFERENCING OLD AS OLD_UPD NEW AS NEW_UPD
FOR EACH ROW
BEGIN
IF (:new_upd.PROC = 1) THEN
al_p_x;
END IF;
IF (:new_upd.PROC = 2) THEN
al_p_y;
END IF;
END;
/
create procedure al_p_x as
begin
delete from t_daten where gj in (select distinct gj from i_daten) and
periode in (select distinct periode from i_daten);
insert into t_daten
select * from i_daten;
end;
/

create procedure al_p_y as
begin
delete from i_daten;
insert into i_daten
select * from t_daten
where gj=(select gj from al_v_a_f_user) and
periode=(select periode from al_v_a_f_user);
end;
/