Oracle | DBMS

Oracle DBMS_MACOUT Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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(

        ELSE

          dbms_output.put_line(

        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