Oracle | DBMS_HS

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	CHECK_FDS_CLASS	CHECK_INST_DD
CHECK_BASE_DD	CHECK_FDS_INST	CHECK_INST_INIT
CHECK_CLASS_CAPS	CHECK_INIT_VALUE_TYPE	CHECK_TRANSLATION_TEXT
CHECK_CLASS_DD	CHECK_INST_CAPS	CHECK_TRANSLATION_TYPE
CHECK_CLASS_INIT

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