Oracle | PRVT_REPORT

Oracle PRVT_REPORT_TAGS 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 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>