web analytics

Write to the alert log from PL/SQL code

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 […]