add_message.sql
-- -- Title : add_message.sql -- Description : Add a custom message to the alert log -- and/or trace file. -- -- Usage/Notes : Run as SYS user, or any user granted -- EXECUTE privilege on DBMS_SYSTEM. -- -- Copyright : ABCdba.com 2011 -- ACCEPT locno NUMBER PROMPT 'Enter location - 1 for trace; 2 for alert log; 3 for both : '; ACCEPT messg PROMPT 'Enter custom message : '; EXEC dbms_system.ksdwrt( &locno , '&messg' );
page revision: 2, last edited: 23 Sep 2011 10:58
