Oracle DBMS_MACOUT
Version 18.1.0.0

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Database Vault Output Buffer Utilities
AUTHID DEFINER
Dependencies
DV$OUT OUT PLITBLM
KZV$UTL_LIBT    
Documented No
First Available 12.1.0.1
Security Model Owned by DVSYS with
Source {ORACLE_HOME}/rdbms/admin/catmacp.sql
Subprograms
 
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;
/
PL
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_MACAUD
DBMS_OUTPUT
What's New In 12cR2
What's New In 18cR1

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved