Writing to the alert log

Using dbms_system.ksdwrt to write to the alert log

Writing to the alert log

SQL> exec dbms_system.ksdwrt(2,'ORA-20000 Manual write to alert log');

PL/SQL procedure successfully completed.

Writing to the udump

SQL> exec dbms_system.ksdwrt(1,'ORA-20000 Manual write udump trc');

PL/SQL procedure successfully completed.

Use 3 to write to both locations.

******************************************
keywords: alert log
******************************************
rdbms version: 9i,10g
******************************************