Difference between revisions of "PL/SQL"

Revision as of 13:18, 1 February 2013

Write directly to the alert log

PROCEDURE write_alert(p_text IN VARCHAR2) IS
BEGIN
    sys.write_log(2,p_text);
END write_alert;

Get default host name and PL/SQL program unit

PROCEDURE log_text ( p_text              IN all_log_messages.text%TYPE
                   , p_server            IN all_log_messages.server%TYPE      DEFAULT utl_inaddr.get_host_name
                   , p_database          IN all_log_messages.database%TYPE    DEFAULT sys.database_name
                   , p_last_check        IN all_log_messages.last_check%TYPE  DEFAULT sysdate
                   , p_severity          IN all_log_messages.severity%TYPE    DEFAULT 'INFO'
                   , p_script_name       IN all_log_messages.script_name%TYPE DEFAULT $$PLSQL_UNIT
                   );