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
Post a Comment