WHy can't you create several triggers in one single script ?
935265May 17 2012 — edited May 17 2012Hi i did a lot of sql requests to create triggers and now i want them to be executed all one after one, so i made a script with all the requests in it, problem is that only the first one executes, why ?
here are the first two requests from the code:
create or replace trigger TRBI_schema_bd_l before insert
on t_schema_bd_l for each row
begin
select SQ_GDI.nextval
into :new.ID_SBL
from dual;
sp_info_element_ctrl(:new.date_dern_maj_ctrl,:new.code_usager_ctrl);
end;
create or replace trigger TRBI_souscriptions before insert
on T_souscription for each row
begin
select SQ_GDI.nextval
into :new.ID_SOUS
from dual;
sp_info_element_ctrl(:new.date_dern_maj_ctrl,:new.code_usager_ctrl);
end;