Oracle | PRVT_REPORT

Oracle PRVT_REPORT_TAGS Version 21c

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 Undocumented

AUTHID CURRENT_USER

Dependencies

DBMS_ASH_INTERNAL	DBMS_STATS_ADVISOR	PRVTEMX_SQL
DBMS_AUTO_INDEX	DBMS_WRR_INTERNAL	PRVT_ASH_OMX
DBMS_AUTO_REPORT	DBMS_XPLAN	PRVT_AWR_VIEWER
DBMS_AUTO_ZONEMAP	DBMS_XPLAN_INTERNAL	PRVT_CPADDM
DBMS_PERF	DUAL	PRVT_SQLPA
DBMS_REPORT	PLITBLM	SYS_IXMLAGG
DBMS_SPM_INTERNAL	PRVTEMX_ADMIN	WRI$_REPT_ADDM
DBMS_SQLTCB_INTERNAL	PRVTEMX_CELL	WRI$_REPT_RTADDM
DBMS_SQLTUNE	PRVTEMX_DBHOME	WRI$_REPT_SQLPI
DBMS_SQLTUNE_INTERNAL	PRVTEMX_MEMORY	WRI$_REPT_SQLT
DBMS_SQLTUNE_UTIL0	PRVTEMX_PERF	XMLAGG
DBMS_STATS	PRVTEMX_RSRCMGR	XMLTYPE

Documented No

Exceptions

Error Code	Reason
ORA-13984	Invalid reference string

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvsrept.plb

Subprograms

BUILD_BINDS_TAG	BUILD_HISTOGRAM_TAG	BUILD_STAT_GROUP_TAG
BUILD_BUCKET_TAG	BUILD_REPORT_REF_TAG	BUILD_STAT_TAG
BUILD_EMPLOYEE_TAG	BUILD_REPORT_TAG	BUILD_XPLAN_TAG
BUILD_FMWK_TEST_TAG	-	-

BUILD_BINDS_TAG

Undocumented prvt_report_tags.build-binds_tag( bind_data IN RAW, masked_binds_flag IN RAW) RETURN sys.xmltype;

TBD

BUILD_BUCKET_TAG

Undocumented prvt_report_tags.build_bucket_tag( range_max IN NUMBER, value IN NUMBER) RETURN sys.xmltype;

SELECT prvt_report_tags.build_bucket_tag(100, 42)

      FROM dual;

      

      PRVT_REPORT_TAGS.BUILD_BUCKET_TAG(100,42)

      -----------------------------------------

      <bucket max="100">42</bucket>

BUILD_EMPLOYEE_TAG

Undocumented

Formatted for clarity prvt_report_tags.build_employee_tag( empno IN NUMBER, ename IN VARCHAR2, sal IN NUMBER) RETURN sys.xmltype;

SELECT prvt_report_tags.build_employee_tag(1, 'Larry Ellison', 999999999999)

      FROM dual;

      

      
      PRVT_REPORT_TAGS.BUILD_EMPLOYEE_TAG(1,'LARRYELLISON',999999999999)

      ------------------------------------------------------------------

      <employee number="1">

        <name>Larry Ellison</name>

        <salary>999999999999</salary>

      </employee>

BUILD_FMWK_TEST_TAG

Undocumented prvt_report_tags.build_fmwk_test_tag( n IN NUMBER, t IN VARCHAR2, x IN sys.xmltype) RETURN sys.xmltype;

TBD

BUILD_HISTOGRAM_TAG

Undocumented prvt_report_tags.bild_histogram_tag( name IN VARCHAR2, buckets IN sys.xmltype) RETURN sys.xmltype;

TBD

BUILD_REPORT_REF_TAG

Undocumented prvt_report_tags.build_report_ref_tag(report_reference IN VARCHAR2) RETURN sys.xmltype;

SELECT prvt_report_tags.build_report_ref_tag('UW_RPT_REF')

      FROM dual;

      

      PRVT_REPORT_TAGS.BUILD_REPORT_REF_TAG('UW_RPT_REF')

      ---------------------------------------------------

      <report_ref><![CDATA[UW_RPT_REF]]></report_ref>

BUILD_REPORT_TAG

Undocumented prvt_report_tags.build_report_tag( report_reference IN VARCHAR2, elapsed_time IN NUMBER, cpu_time IN NUMBER, base_path IN VARCHAR2) RETURN sys.xmltype;

SELECT prvt_report_tags.build_report_tag('UWREF', 10, 12, 'bPath')

      FROM dual;

      ERROR:

      ORA-13984: Invalid reference string

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79

      ORA-06512: at "SYS.DBMS_REPORT", line 692

      ORA-06512: at "SYS.PRVT_REPORT_TAGS", line 25

      ORA-06512: at line 1

BUILD_STAT_GROUP_TAG

Undocumented prvt_report_tags.build_stat_group_tag( name IN VARCHAR2, children IN sys.xmltype) RETURN sys.xmltype;

TBD

BUILD_STAT_TAG

Undocumented prvt_report_tags.build_stat_tag( name IN VARCHAR2, value IN NUMBER) RETURN sys.xmltype;

SELECT prvt_report_tags.build_stat_tag('TEST', 42)

      FROM dual;

      

      PRVT_REPORT_TAGS.BUILD_STAT_TAG('TEST',42)

      ------------------------------------------

      <stat name="TEST">42</stat>

BUILD_XPLAN_TAG

Undocumented

Output formatted for clarity prvt_report_tags.build_xplan_tag( table_name IN VARCHAR2, statement_id IN VARCHAR2, plan_id IN NUMBER, plan_hash IN NUMBER, qualifier IN VARCHAR2, format IN VARCHAR2) RETURN sys.xmltype;

SELECT prvt_report_tags.build_xplan_tag('SERVERS', 'AA', '12', 272002086, 'BB', 'HTML')

      FROM dual;

      

      PRVT_REPORT_TAGS.BUILD_XPLAN_TAG('SERVERS','AA','12',272002086,'BB','HTML')

      ----------------------------------------------------------------------------------------<plan id="12" hash="272002086" type="BB">

        <error>

          <![CDATA[ Error: format 'HTML' not valid for DBMS_XPLAN.BUILD_PLAN_XML()]]>

        </error>

      </plan>