Write a Message to the Alert Log

Posted By Sagar Patil

One can use UTL_FILE else OS editors/utilities. The best is using undocumented KSDWRT procedure of the DBMS_SYSTEM package.

This procedure has two parameters,  The first one must be “2” to write to the alert file,  the second one is the message you want to write.

execute sys.dbms_system.ksdwrt(2,to_char(sysdate)|| ‘ — ‘);

I used it to write “ORA-“ Error messages at Alrtlog to Test grid alerts for targets.

Leave a Reply

You must be logged in to post a comment.

Top of Page

Top menu