Difference between revisions of "PL/SQL"

Revision as of 13:17, 1 February 2013

Write directly to the alert log

</pre>

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

</pre>

Get default host name and PL/SQL program unit

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

</pre>