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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_HS
DBMS_HS_ALT
DBMS_HS_CHK
DBMS_HS_PARALLEL
DBMS_HS_PARALLEL_METADATA
DBMS_HS_PASSTHROUGH
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