Oracle | PRVT_REPORT

Oracle PRVT_REPORT_TAGS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Undocumented

AUTHID CURRENT_USER

Dependencies

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

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);

      

      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);

      

      
      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');

      

      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');

      ERROR:

      ORA-13984: Invalid reference string

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);

      

      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');

      

      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>