multiple trigger for one event

Hi there ..

I have a table with 2 before-insert-triggers. The second one need the result of trigger one. Can I prescribed the order for this triggers ?

action of trigger 1:

      BEFORE INSERT ON T001
       REFERENCING NEW AS NEW   
       FOR EACH ROW 


        ...	

        SELECT Sequence1.nextval  INTO x_T001_id  FROM dual; 
        :NEW.T001_id:= x_T001_id; 
        ...

action of trigger 2:

      BEFORE INSERT ON T001
       REFERENCING NEW AS NEW   
       FOR EACH ROW 


        ...	

       SELECT Sequence2.nextval  INTO x_T002_id  FROM dual; 
       INSERT INTOT002
           ( T002_id,  T002_T001_id )
       VALUES 
           ( x_T002_id, :NEW.T001_id  );
       ...

Trigger 1 is existing in DB .. the second one must be generate dynamic. Combining both triggers is not possible !!

Have anyone an idea ??

Thanx in advance
Robert Received on Tue Mar 18 2003 - 02:01:37 CST