PL/SQL - Revision history

Stuart at 13:23, 8 September 2016

2016-09-08T13:23:10Z

Stuart at 13:22, 8 September 2016

2016-09-08T13:22:45Z

Stuart at 13:18, 1 February 2013

2013-02-01T13:18:27Z

Stuart at 13:18, 1 February 2013

2013-02-01T13:18:04Z

Stuart: Created page with "===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..."

2013-02-01T13:17:48Z

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..."

New page

===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>

@@ Line 1: / Line 1: @@
 ===Write directly to the alert log===
 <pre>
 PROCEDURE write_alert(p_text IN VARCHAR2) IS

@@ Line 1: / Line 1: @@
 ===Write directly to the alert log===
-</pre>
+<pre>
     PROCEDURE write_alert(p_text IN VARCHAR2) IS
     BEGIN
@@ Line 8: / Line 8: @@
 ===Get default host name and PL/SQL program unit===
-</pre>
+<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