20070615

create or replace trigger "SPC".tig_rel_routing_tec
before insert on spc.rel_routing_tec
for each row

begin

--select distinct num,id into :new.num,:new.technic_id  from spc.view_Tech_Tec_num where tech_id =:new.tech_id ;
--update spc.rel_routing_tec set num=L_num,technic_id =L_technic_id where tech_id=:new.tech_id;
select distinct tech_id    into :new.technic_id  from spc.rel_tec_technic where technic_id  =:new.tech_id ;
select distinct tech_num into :new.num  from spc.rel_routing_tech  where tech_id =:new.technic_id ;

end;