Report problems to ATLAS LXR Team (with time and IP address indicated) |
|
[ source navigation ] [ diff markup ] [ identifier search ] [ general search ] |
||||
|
||||||
Links to LXR source navigation pages for stable releases | [ 12.*.* ] [ 13.*.* ] [ 14.*.* ] |
001 -- PROJECT: ATLAS MDT Calibration DB 002 -- AUTHOR: Elisabetta.Vilucchi@lnf.infn.it, celio@roma3.infn.it 003 -- DATE: May 08 004 -- VERSION v1r1 005 006 --USAGE: 007 --sqlplus <USER_NAME>/<USER_PASSWORD> @mdt_rt_map_r_trigger.sql <USER_NAME> 008 009 --DROP TRIGGER &1..MDT_RT_MAP_R_TRIGGER; 010 CREATE TRIGGER &1..MDT_RT_MAP_R_TRIGGER BEFORE 011 INSERT ON &1.."MDT_RT_MAP_R" REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW 012 BEGIN 013 014 SELECT &1..MDT_RT_MAP_R_SEQUENCE.NEXTVAL INTO :NEW.MDT_RT_MAP_R_ID FROM DUAL; 015 SELECT TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DD HH:MI AM') INTO :NEW.INSERT_TIME FROM DUAL; 016 017 EXCEPTION 018 WHEN OTHERS THEN 019 RAISE; 020 END MDT_RT_MAP_R_TRIGGER; 021 /
[ source navigation ] | [ diff markup ] | [ identifier search ] | [ general search ] |
Due to the LXR bug, the updates fail sometimes to remove references to deleted files. The Saturday's full rebuilds fix these problems | |
This page was automatically generated by the LXR engine. |