Oracle Logbook

October 20, 2008

Writing on alert

Filed under: Uncategorized — Helio Dias @ 6:42 pm

Sometimes you want to log your own message on alert

just use package ksdwrt

e.g.: dbms_system.ksdwrt(2,’ORA-00600: URGENT – starting 4031 PROJECTS BY Helio Dias’);

I wrote the message started with 00600 to allow our monitoring tool “see” the error.

First parameter (2) write message on alert, (1) write on trace files

Blog at WordPress.com.