Difference between revisions of "PL/SQL"
From dbawiki
(Created page with "===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...") |
|||
| Line 1: | Line 1: | ||
===Write directly to the alert log=== | ===Write directly to the alert log=== | ||
| − | < | + | <pre> |
PROCEDURE write_alert(p_text IN VARCHAR2) IS | PROCEDURE write_alert(p_text IN VARCHAR2) IS | ||
BEGIN | BEGIN | ||
| Line 8: | Line 8: | ||
===Get default host name and PL/SQL program unit=== | ===Get default host name and PL/SQL program unit=== | ||
| − | < | + | <pre> |
PROCEDURE log_text ( p_text IN all_log_messages.text%TYPE | 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_server IN all_log_messages.server%TYPE DEFAULT utl_inaddr.get_host_name | ||
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
);
