Oracle: DBMS_SYSTEM.KSDWRT

dbms_system.ksdwrt writes messages to a trace file or the alert log.

The first parameter specifies the destination of the message (of the second parameter):

• 1: trace file
• 2: alert log
• 3: trace file and alert log

dbms_system also defines two constants for these values: trace_file (= 1) and alert_file (= 2).

begin
   dbms_system.ksdwrt(2, 'Hello alert log');
end;
/