Oracle DBMS_HS_CHK
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 DEFINER
Dependencies
DBMS_HS HS$_CLASS_CAPS HS$_FDS_INST
DBMS_HS_ALT HS$_CLASS_DD HS$_INST_CAPS
DBMS_HS_UTL HS$_CLASS_INIT HS$_INST_DD
HS$_BASE_CAPS HS$_FDS_CLASS HS$_INST_INIT
HS$_BASE_DD    
Documented No
Exceptions
Error Code Reason
ORA-24274 no row exists in the HS$_BASE_DD table for these parameters
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvths.plb
Subprograms
 
CHECK_BASE_CAPS
Undocumented dbms_hs_chk.check_base_caps(cap_number IN NUMBER) RETURN NUMBER;
TBD
 
CHECK_BASE_DD
Checks to determine whether a table is listed in HS$_BASE_DD dbms_hs_chk.check_base_dd(dd_table_name IN VARCHAR2) RETURN NUMBER;
SELECT dbms_hs_chk.check_base_dd('TAB$')
FROM dual;
SELECT dbms_hs_chk.check_base_dd('TAB$')
*
ERROR at line 1:
ORA-24274: no row exists in the HS$_BASE_DD table for these parameters
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_HS_UTL", line 431
ORA-06512: at "SYS.DBMS_HS_CHK", line 66


desc HS$_BASE_DD
Name                Null?    Type
------------------- -------- -------------
DD_TABLE_ID         NOT NULL NUMBER
DD_TABLE_NAME       NOT NULL VARCHAR2(128)
DD_TABLE_DESC                VARCHAR2(255)


SELECT COUNT(*) FROM hs$_base_dd;

COUNT(*)
----------
102


SELECT * FROM hs$_base_dd WHERE rownum < 11;

DD_TABLE_ID DD_TABLE_NAME DD_TABLE_DESC
----------- --------------- ---------------
          1 DD_TKHODDTR1
          2 DD_TKHODDTR3
          3 DD_TKHODDTR5
          4 DD_TKHODDTR6
          5 DD_TKHODDTR7
          6 DD_TKHODDTR8
          7 DD_TKHODDTR9
          8 DD_TKHODDTR10
          9 ALL_CATALOG
         10 ALL_COL_COMMENT


SELECT dbms_hs_chk.check_base_dd('ALL_CATALOG')
FROM dual;

DBMS_HS_CHK.CHECK_BASE_DD('ALL_CATALOG')
----------------------------------------
                                       9
 
CHECK_CLASS_CAPS
Undocumented dbms_hs_chk.check_class_caps(
fds_class_name IN VARCHAR2,
cap_number     IN NUMBER)
RETURN NUMBER;
TBD
 
CHECK_CLASS_DD
Undocumented dbms_hs_chk.check_class_dd(
fds_class_name IN VARCHAR2,
dd_table_name  IN VARCHAR2)
RETURN NUMBER;
TBD
 
CHECK_CLASS_INIT
Undocumented dbms_hs_chk.check_class_init(
fds_class_name  IN VARCHAR2,
init_value_name IN VARCHAR2)
RETURN NUMBER;
TBD
 
CHECK_FDS_CLASS
Undocumented dbms_hs_chk.check_fds_class(fds_class_name IN VARCHAR2) RETURN NUMBER;
TBD
 
CHECK_FDS_INST
Undocumented dbms_hs_chk.check_fds_inst(
fds_inst_name  IN VARCHAR2,
fds_class_name IN VARCHAR2)
RETURN NUMBER;
TBD
 
CHECK_INIT_VALUE_TYPE
Undocumented dbms_hs_chk.check_init_value_type(init_value_type IN VARCHAR2);
TBD
 
CHECK_INST_CAPS
Undocumented dbms_hs_chk.check_inst_caps(
fds_inst_name  IN VARCHAR2,
fds_class_name IN VARCHAR2,
cap_number     IN NUMBER)
RETURN NUMBER;
TBD
 
CHECK_INST_DD
Undocumented dbms_hs_chk.check_inst_dd(
fds_inst_name  IN VARCHAR2,
fds_class_name IN VARCHAR2,
dd_table_name  IN VARCHAR2)
RETURN NUMBER;
TBD
 
CHECK_INST_INIT
Undocumented dbms_hs_chk.check_inst_init(
fds_inst_name   IN VARCHAR2,
fds_class_name  IN VARCHAR2,
init_value_name IN VARCHAR2)
RETURN NUMBER;
TBD
 
CHECK_TRANSLATION_TEXT
Undocumented dbms_hs_chk.check_translation_text(
translation_text IN VARCHAR2,
translation_type IN VARCHAR2);
TBD
 
CHECK_TRANSLATION_TYPE
Undocumented dbms_hs_chk.check_translation_type(translation_type IN CHAR);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_HS
DBMS_HS_ALT
DBMS_HS_PARALLEL
DBMS_HS_PARALLEL_METADATA
DBMS_HS_PASSTHROUGH
DBMS_HS_UTL
What's New In 21c
What's New In 23c

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