Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE PACKAGE alertlog_pkg
- IS
- TYPE b
- IS
- RECORD
- (
- author VARCHAR2(100) DEFAULT 'Brian Fitzgerald',
- email VARCHAR2(100) DEFAULT 'brian@exagriddba.com',
- twitter VARCHAR2(100) DEFAULT 'ExaGridDba' );
- PROCEDURE printf(
- p_format IN VARCHAR2,
- p_arg1 IN VARCHAR2 DEFAULT NULL,
- p_arg2 IN VARCHAR2 DEFAULT NULL,
- p_arg3 IN VARCHAR2 DEFAULT NULL,
- p_arg4 IN VARCHAR2 DEFAULT NULL,
- p_arg5 IN VARCHAR2 DEFAULT NULL,
- p_arg6 IN VARCHAR2 DEFAULT NULL,
- p_arg7 IN VARCHAR2 DEFAULT NULL,
- p_arg8 IN VARCHAR2 DEFAULT NULL,
- p_arg9 IN VARCHAR2 DEFAULT NULL);
- END alertlog_pkg;
- /
- show errors
- CREATE OR REPLACE PACKAGE BODY alertlog_pkg
- IS
- PROCEDURE printf(
- p_format IN VARCHAR2,
- p_arg1 IN VARCHAR2 DEFAULT NULL,
- p_arg2 IN VARCHAR2 DEFAULT NULL,
- p_arg3 IN VARCHAR2 DEFAULT NULL,
- p_arg4 IN VARCHAR2 DEFAULT NULL,
- p_arg5 IN VARCHAR2 DEFAULT NULL,
- p_arg6 IN VARCHAR2 DEFAULT NULL,
- p_arg7 IN VARCHAR2 DEFAULT NULL,
- p_arg8 IN VARCHAR2 DEFAULT NULL,
- p_arg9 IN VARCHAR2 DEFAULT NULL)
- IS
- BEGIN
- 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));
- END printf;
- END alertlog_pkg;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement