The following undocumented function could be used to write to the alert log:
EXECUTE sys.dbms_system.ksdwrt(code, message);
Parameters:
1 – Write to trace file.
2 – Write to alertlog.
3 – Write to both.
Example:
EXECUTE sys.dbms_system.ksdwrt(2,TO_CHAR(SYSDATE, 'Dy Mon DD HH24:MI:SS YYYY')||'Hello!' );
CREATE OR REPLACE TRIGGER trg_delme
BEFORE UPDATE ON frodo.delme
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
sys.dbms_system.ksdwrt(2,TO_CHAR(SYSDATE, 'Dy Mon DD HH24:MI:SS YYYY') );
END;
BEFORE UPDATE ON frodo.delme
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
sys.dbms_system.ksdwrt(2,TO_CHAR(SYSDATE, 'Dy Mon DD HH24:MI:SS YYYY') );
END;
Leave a Reply