After Insert Trigger

Posted in 1998

PRAVEEN MOHANAN — Mon, 20 Apr 1998 11:05:04 PDT — source: Informix-list mailing list archive (1991-1998)

Hi..Users... I am calling a procedure from a trigger. Now i want to send the few fields of the record which i am inserting into the table to the procedure. eg: CREATE TRIGGER abcd INSERT ON table_abc REFERENCING NEW AS newAFTER (EXECUTE PROCEDURE oulpr_iclocation(:new.val1, :new.val2,....)); I am able to call the procedure in AFTER clause but with out any parameters . The record "new." stores the value only when "FOR EACH ROW" is used. I want to execute the proceudure only if the record is inserted successfully. Regards, Praveen ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com