Hi, I have this scenarion. I created table1 with id, prod_id and lang_id field, (id is the primary key). then I created table2 with field id and date. (again id is primary key). I created a trigger which will populate table2 upon insert on table1. May method on insert for table1 is via script, the id will be populated by the output of a sequence i created then the prod_id and lang_id field is lets say data from other table. Upon execution of the insert script I always encounter this error. ORA-0001 unique constraint schema.XXXX violated ORA-06512 at SYS_TRIGGER ORA-04088 error during execution of trigger SYS_TRIGGER pls help me with this problem thanks! here are my trigger script and insert script: THANK YOU! you help is really appreciated.