Oracle | DBMS_HS

Oracle DBMS_HS_CHK 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 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$');

            
      *

      ORA-24274: no row exists in the HS$_BASE_DD table for these parameters

      
      

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

      

      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