Oracle Trigger示例01

ceozhg2009

于 2012-02-01 09:39:21 发布

阅读量350

点赞数

分类专栏： ORACLE 文章标签： oracle query insert exception each null

本文链接：https://blog.csdn.net/ceozhg2009/article/details/7224546

版权

ORACLE 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

CREATE OR REPLACE TRIGGER DEMANTRA.XXDM_TRIG_INSERT_PORTAL_TASK
 AFTER
  INSERT
 ON PORTAL_TASK
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
declare
    v_query_id    NUMBER     :=-1;
begin
   BEGIN
        v_query_id := :new.query_id;
        xxdm_util_pkg.insert_step_log_task(v_query_id,'O',:new.source,:new.user_id,:new.message,:new.description);
   EXCEPTION
   WHEN OTHERS THEN
      NULL;
   END;

end;
/