compiler errors - Trigger Compilation Issues - Oracle 10g -


i trying create trigger when user inserts table, trigger join table , insert primary one. here trigger have created far. when insert database "warning: trigger created compilation errors."

create or replace trigger tbi_persons_idm_staging after insert on persons_idm_staging  each row begin if :new.person not in (select person persons) , inserting    insert persons (         person,          dblogin_id,          last_name,          first_name,          department,          jobtitle,          userlevel,          facility_id,          user_options,          password) values(:new.person,         :new.person,         :new.last_name,         :new.first_name,         :new.department,         :new.jobtitle,         :new.userlevel,         (select kms_facility_id facility_idm_staging facility_idm_staging.idm_code = :new.idm_code),         :new.user_options,         :new.password);   end if; end; / 

can see i'm doing wrong?

update: able fix code. here correct statement if else has issue:

create or replace trigger tai_persons_idm_staging after insert on persons_idm_staging  each row  begin     insert persons (             person,              dblogin_id,              last_name,              first_name,              department,              jobtitle,              userlevel,              facility_id,              user_options,              password)     values(:new.person,             :new.person,             :new.last_name,             :new.first_name,             :new.department,             :new.jobtitle,             :new.userlevel,             (select kms_facility_id facility_idm_staging facility_idm_staging.idm_code = :new.idm_code),             :new.user_options,             :new.password);     exception         when dup_val_on_index null; end; / 


Comments