Oracle | DBMS

Oracle DBMS_MACOUT Version 22c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Database Vault Output Buffer Utilities

AUTHID DEFINER

Dependencies

DV$OUT	OUT	PLITBLM
KZV$UTL_LIBT

Documented No

First Available 12.1

Security Model Owned by DVSYS with EXECUTE granted to the DV_ADMIN role.

Source {ORACLE_HOME}/rdbms/admin/catmacp.sql

Subprograms

DISABLE	GET_LINE_COUNT	PL
ENABLE	IS_ENABLED	PUT_LINE
GET_LINE

DISABLE

Disables buffer output dbms_macout.disable;

See GET_LINE Demo Below

ENABLE

Enables buffer output dbms_macout.enable;

See GET_LINE Demo Below

GET_LINE

Returns a line of text from the buffer dbms_macout.get_line(n IN NUMBER) RETURN VARCHAR2;

DECLARE

       retVal VARCHAR2(60);

      BEGIN

        dvsys.dbms_macout.enable;

        dvsys.dbms_macout.put_line('Morgan');

        dbms_output.put_line(  dvsys.dbms_macout.get_line_count);

        retVal := dvsys.dbms_macout.get_line(1);

        dbms_output.put_line(retVal);

        dvsys.dbms_macout.disable;

      END;

      /

      2

      Morgan

GET_LINE_COUNT

Returns the number of lines in the buffer dbms_macout.get_line_count RETURN NUMBER;

See GET_LINE Demo Above

IS_ENABLED

Returns TRUE if tracing is enabled: Otherwise FALSE dbms_macout.is_enabled RETURN BOOLEAN;

BEGIN

        IF dbms_macout.is_enabled THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

Add a new line of text to the output buffer ... the same as PUT_LINE dbms_macout.pl(s IN VARCHAR2);

exec dbms_macout.pl('MLib')

PUT_LINE

Add a new line of text to the output buffer dbms_macout.put_line(s IN VARCHAR2);

See GET_LINE Demo Above