>- see footer for list info -< Hi All, I face a problem with trigger function in Oracle. Here the scenario, I need to perform manual update and insert to certain table but that table got a trigger. So when I run my cf program with the update and insert query,oracle will sent an error because only that table been update but other table not update.
Trigger code :- create or replace TRIGGER "TERRA_DBA".proj_ver_status_history_trig AFTER INSERT OR UPDATE OR DELETE ON project_version_status_history REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN IF (UPDATING OR INSERTING) THEN UPDATE project_version SET modified_date = SYSDATE, modified_by = :new.modified_by WHERE prj_master_id = :new.prj_master_id AND prj_version_id = :new.prj_version_id; ELSE UPDATE project_version SET modified_date = SYSDATE WHERE prj_master_id = :old.prj_master_id AND prj_version_id = :old.prj_version_id; END IF; END; Problem is i dont know how to update the table and make sure that trigger also running correctly. Anyone face this issue? I cannot diabled the trigger because DBA not allowed to do so. Please Help, Regards, Shaffiq _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
