Showing posts with label message. Show all posts
Showing posts with label message. Show all posts

01 March 2011

Write your own message into alert log


Run under SYS
begin
  dbms_system.ksdwrt(2, 'Message from DB');
end;

Original
dbms_system.ksdwrt(n, message_string);
where n is:
1 - Write to trace file.
2 - Write to alertlog.
3 - Write to both.