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