Oracle DBMS_AUTO_REPORT_INTERNAL
Version 12.2.0.1

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 Support package for DBMS_AUTO_REPORT
AUTHID DEFINER
Dependencies
DBA_HIST_REPORTS_DETAILS DBMS_SQLTUNE_UTIL2 WRP$_REPORTS
DBMS_LOB DUAL WRP$_REPORTS_DETAILS
DBMS_REPORT PLITBLM WRP$_REPORTS_TIME_BANDS
DBMS_REPORT_LIB PRVT_RTADDM WRP$_REPORT_ID_SEQ
DBMS_SQLTUNE_UTIL1 UTL_COMPRESS XMLTYPE
Documented No
First Available 12.1.0
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvsautorepi.plb
Subprograms
 
I_SAVE_REPORT
Undocumented dbms_auto_report_internal.i_save_report(
report_ref IN  VARCHAR2,
snap_id    IN  BINARY_INTEGER,
pr_class   IN  BINARY_INTEGER,
report_id  OUT BINARY_INTEGER,
success    OUT BINARY_INTEGER);
TBD
 
I_UNCOMPRESS_REPORT
Undocumented dbms_auto_report_internal.i_uncompress_report(report_in IN BLOB) RETURN CLOB;
-- the following code from catrepv.sql illustrates this function's use
CREATE OR REPLACE VIEW dba_hist_reports_details
(SNAP_ID, DBID, INSTANCE_NUMBER, REPORT_ID, SESSION_ID,
 SESSION_SERIAL#, GENERATION_TIME, REPORT_COMPRESSED, REPORT)
AS
SELECT snap_id, dbid, instance_number, report_id,
  session_id, session_serial#, generation_time, report_compressed,
  dbms_auto_report_internal.i_uncompress_report(report_compressed)
FROM wrp$_reports_details d
/

Related Topics
DBMS_AUTO_REPORT
Packages
What's New In 12cR1
What's New In 12cR2

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