Oracle | DBMS_HS

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

SQL> @?/rdbms/admin/prvths.plb

      

      Session altered.

      

      SP2-0808: Package created with compilation warnings

      

      SP2-0808: Package created with compilation warnings

      

      SP2-0808: Package created with compilation warnings

      

      SP2-0810: Package Body created with compilation warnings

      

      Package body created.

      

      SP2-0810: Package Body created with compilation warnings

      

      SP2-0810: Package Body created with compilation warnings

      

      Type created.

      

      Type created.

      

      Function created.

      

      Grant succeeded.

      

      Synonym created.

      

      Type created.

      

      Type created.

      

      Function created.

      

      Grant succeeded.

      

      Type created.

      

      Type created.

      

      Function created.

      

      Grant succeeded.

      

      Type created.

      

      Type created.

      

      Function created.

      

      Grant succeeded.

      

      Synonym created.

      

      Type created.

      

      Type created.

      

      Function created.

      

      Grant succeeded.

      

      Type created.

      

      Type created.

      

      Function created.

      

      Grant succeeded.

      

      Type created.

      

      Type created.

      

      Function created.

      

      Grant succeeded.

      

      Type created.

      

      Type created.

      

      Function created.

      

      Grant succeeded.

      

      SP2-0816: Type created with compilation warnings

      

      Type created.

      

      SP2-0806: Function created with compilation warnings

      

      Grant succeeded.

      

      SP2-0816: Type created with compilation warnings

      

      Type created.

      

      SP2-0806: Function created with compilation warnings

      

      Grant succeeded.

      

      Function created.

      

      Grant succeeded.

      

      Function created.

      

      Grant succeeded.

      

      Function created.

      

      Grant succeeded.

      

      Function created.

      

      Grant succeeded.

      

      SP2-0806: Function created with compilation warnings

      

      Grant succeeded.

      

      SP2-0806: Function created with compilation warnings

      

      Grant succeeded.

      

      Commit complete.

      

      Session altered.

      SQL> sho err

      Errors for FUNCTION SYS.HS$_DDTF_OPTTABSTATS:

      

      LINE/COL ERROR

      ------------------------------------------------------------------------

      26/3 PLW-06010: keyword "TYPE" used as a defined name

      30/3 PLW-05004: identifier CARDINALITY is also declared in STANDARD or is a SQL builtin

      42/8PLW-06010: keyword "TYPE" used as a defined name

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

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

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

      ORA-06512: at "SYS.DBMS_HS_UTL", line 431

      ORA-06512: at line 1