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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_REPORT
PRVT_AWR_VIEWER
PRVT_REPORT_REGISTRY
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx