Advertisement
ExaGridDba

alertlog_pkg: printf to the alert log

Nov 2nd, 2015
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 1.31 KB | None | 0 0
  1.  
  2. CREATE OR REPLACE PACKAGE alertlog_pkg
  3. IS
  4. TYPE b
  5. IS
  6.   RECORD
  7.   (
  8.     author  VARCHAR2(100) DEFAULT 'Brian Fitzgerald',
  9.     email   VARCHAR2(100) DEFAULT 'brian@exagriddba.com',
  10.     twitter VARCHAR2(100) DEFAULT 'ExaGridDba' );
  11.  
  12.   PROCEDURE printf(
  13.       p_format IN VARCHAR2,
  14.       p_arg1   IN VARCHAR2 DEFAULT NULL,
  15.       p_arg2   IN VARCHAR2 DEFAULT NULL,
  16.       p_arg3   IN VARCHAR2 DEFAULT NULL,
  17.       p_arg4   IN VARCHAR2 DEFAULT NULL,
  18.       p_arg5   IN VARCHAR2 DEFAULT NULL,
  19.       p_arg6   IN VARCHAR2 DEFAULT NULL,
  20.       p_arg7   IN VARCHAR2 DEFAULT NULL,
  21.       p_arg8   IN VARCHAR2 DEFAULT NULL,
  22.       p_arg9   IN VARCHAR2 DEFAULT NULL);
  23.  
  24. END alertlog_pkg;
  25. /
  26. show errors
  27.  
  28. CREATE OR REPLACE PACKAGE BODY alertlog_pkg
  29. IS
  30. PROCEDURE printf(
  31.     p_format IN VARCHAR2,
  32.     p_arg1   IN VARCHAR2 DEFAULT NULL,
  33.     p_arg2   IN VARCHAR2 DEFAULT NULL,
  34.     p_arg3   IN VARCHAR2 DEFAULT NULL,
  35.     p_arg4   IN VARCHAR2 DEFAULT NULL,
  36.     p_arg5   IN VARCHAR2 DEFAULT NULL,
  37.     p_arg6   IN VARCHAR2 DEFAULT NULL,
  38.     p_arg7   IN VARCHAR2 DEFAULT NULL,
  39.     p_arg8   IN VARCHAR2 DEFAULT NULL,
  40.     p_arg9   IN VARCHAR2 DEFAULT NULL)
  41. IS
  42. BEGIN
  43.         dbms_system.ksdwrt(2, out_pkg.sprintf( p_format, p_arg1, p_arg2, p_arg3, p_arg4, p_arg5, p_arg6, p_arg7, p_arg8, p_arg9));
  44. END printf;
  45.  
  46. END alertlog_pkg;
  47. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement