PL/SQL

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