Oracle | DBMS_HS

Oracle DBMS_HS_UTL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Heterogeneous Services Utilities

AUTHID DEFINER

Dependencies

DBMS_HS	HS$_CLASS_INIT	HS$_INST_DD_S
DBMS_HS_ALT	HS$_CLASS_INIT_S	HS$_INST_INIT
DBMS_HS_CHK	HS$_FDS_CLASS	HS$_INST_INIT_S
DBMS_SYS_ERROR	HS$_FDS_CLASS_DATE	HS_CLASS_CAPS
HS$_BASE_CAPS	HS$_FDS_CLASS_S	HS_CLASS_DD
HS$_BASE_DD	HS$_FDS_INST	HS_CLASS_INIT
HS$_BASE_DD_S	HS$_FDS_INST_S	HS_FDS_INST
HS$_CLASS_CAPS	HS$_INST_CAPS	HS_INST_CAPS
HS$_CLASS_CAPS_S	HS$_INST_CAPS_S	HS_INST_DD
HS$_CLASS_DD	HS$_INST_DD	HS_INST_INIT
HS$_CLASS_DD_S

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvths.plb

Subprograms

CANONICALIZE	CREATE_FDS_CLASS	DROP_CLASS_INIT
CANON_EXTOBJ	CREATE_FDS_INST	DROP_FDS_CLASS
COPY_CLASS	CREATE_INST_CAPS	DROP_FDS_INST
COPY_INST	CREATE_INST_DD	DROP_INST_CAPS
CREATE_BASE_CAPS	CREATE_INST_INIT	DROP_INST_DD
CREATE_BASE_DD	DROP_BASE_CAPS	DROP_INST_INIT
CREATE_CLASS_CAPS	DROP_BASE_DD	GET_TRANS_TYPE
CREATE_CLASS_DD	DROP_CLASS_CAPS	RAISE_SYSTEM_ERROR
CREATE_CLASS_INIT	DROP_CLASS_DD

CANONICALIZE

Undocumented dbms_hs_utl.canonicalize( name IN VARCHAR2, canon_name IN OUT VARCHAR2, canon_len IN NUMBER);

TBD

CANON_EXTOBJ

Undocumented dbms_hs_utl.canon_extobj( name IN VARCHAR2, canon_name IN OUT VARCHAR2, canon_len IN NUMBER);

TBD

COPY_CLASS

Undocumented dbms_hs_utl.copy_class( old_fds_class_name IN VARCHAR2, new_fds_class_name IN VARCHAR2, new_fds_class_comments IN VARCHAR2);

TBD

COPY_INST

Undocumented dbms_hs_utl.copy_inst( old_fds_inst_name IN VARCHAR2, old_fds_class_name IN VARCHAR2, new_fds_inst_name IN VARCHAR2, new_fds_inst_comments IN VARCHAR2);

TBD

CREATE_BASE_CAPS

Undocumented dbms_hs_utl.create_base_caps( cap_number IN NUMBER, cap_description IN VARCHAR2);

TBD

CREATE_BASE_DD

Undocumented dbms_hs_utl.create_base_dd( dd_table_name IN VARCHAR2, dd_table_desc IN VARCHAR2);

TBD

CREATE_CLASS_CAPS

Undocumented dbms_hs_utl.create_class_caps( fds_class_name IN VARCHAR2, cap_number IN NUMBER, context IN NUMBER, translation IN VARCHAR2, additional_info IN NUMBER);

TBD

CREATE_CLASS_DD

Undocumented dbms_hs_utl.create_class_dd( fds_class_name IN VARCHAR2, dd_table_name IN VARCHAR2, translation_type IN CHAR, translation_text IN VARCHAR2);

TBD

CREATE_CLASS_INIT

Undocumented dbms_hs_utl.create_class_init( fds_class_name IN VARCHAR2, init_value_name IN VARCHAR2, init_value IN VARCHAR2, init_value_type IN VARCHAR2);

TBD

CREATE_FDS_CLASS

Undocumented dbms_hs_utl.create_fds_class( fds_class_name IN VARCHAR2, fds_class_comments IN VARCHAR2);

TBD

CREATE_FDS_INST

Undocumented dbms_hs_utl.create_fds_inst( fds_inst_name IN VARCHAR2, fds_class_name IN VARCHAR2, fds_inst_comments IN VARCHAR2);

TBD

CREATE_INST_CAPS

Undocumented dbms_hs_utl.create_inst_caps( fds_inst_name IN VARCHAR2, fds_class_name IN VARCHAR2, cap_number IN NUMBER, context IN NUMBER, translation IN VARCHAR2, additional_info IN NUMBER);

TBD

CREATE_INST_DD

Undocumented dbms_hs_utl.create_inst_dd( fds_inst_name IN VARCHAR2, fds_class_name IN VARCHAR2, dd_table_name IN VARCHAR2, translation_type IN CHAR, translation_text IN VARCHAR2);

TBD

CREATE_INST_INIT

Undocumented dbms_hs_utl.create_inst_init( fds_inst_name IN VARCHAR2, fds_class_name IN VARCHAR2, init_value_name IN VARCHAR2, init_value IN VARCHAR2, init_value_type IN VARCHAR2);

TBD

DROP_BASE_CAPS

Undocumented dbms_hs_utl.drop_base_caps(cap_number IN NUMBER);

exec dbms_hs_utl.drop_base_caps(42);

      

      PL/SQL procedure successfully completed.

DROP_BASE_DD

Undocumented dbms_hs_utl.drop_base_dd(dd_table_name IN VARCHAR2);

TBD

DROP_CLASS_CAPS

Undocumented dbms_hs_utl.drop_class_caps( fds_class_name IN VARCHAR2, cap_number IN NUMBER);

TBD

DROP_CLASS_DD

Undocumented dbms_hs_utl.drop_class_dd( fds_class_name IN VARCHAR2, dd_table_name IN VARCHAR2);

TBD

DROP_CLASS_INIT

Undocumented dbms_hs_utl.drop_class_init( fds_class_name IN VARCHAR2, init_value_name IN VARCHAR2);

TBD

DROP_FDS_CLASS

Undocumented dbms_hs_utl.drop_fds_class(fds_class_name IN VARCHAR2);

TBD

DROP_FDS_INST

Undocumented dbms_hs_utl.drop_fds_int( fds_inst_name IN VARCHAR2, fds_class_name IN VARCHAR2);

TBD

DROP_INST_CAPS

Undocumented dbms_hs_utl.drop_inst_caps( fds_inst_name IN VARCHAR2, fds_class_name IN VARCHAR2, cap_number IN NUMBER);

TBD

DROP_INST_DD

Undocumented dbms_hs_utl.drop_inst_dd( fds_inst_name IN VARCHAR2, fds_class_name IN VARCHAR2, dd_table_name IN VARCHAR2);

TBD

DROP_INST_INIT

Undocumented dbms_hs_utl.drop_inst_init( fds_inst_name IN VARCHAR2, fds_class_name IN VARCHAR2, init_value_name IN VARCHAR2);

TBD

GET_TRANS_TYPE

Undocumented dbms_hs_utl.get_trans_type( pk_id IN NUMBER, tab_name IN VARCHAR2) RETURN VARCHAR2;

TBD

RAISE_SYSTEM_ERROR

Raises an exception if, unlike in the demo at right, you have the correct error number and argument correlation dbms_hs_utl.raise_system_error( error_number IN NUMBER, arg1 IN VARCHAR2);

exec dbms_hs_utl.raise_system_error(-28522, 'error initializing heterogeneous capabilities');

          
      *

      ORA-21001: error number argument to raise_system_error of -28522 is out of range