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' );

© copyright 2001-2014 ABCdba.com | all rights reserved