Release 8.1.5
A68001-01
 Library |
 Product |
 Contents |
 Index |
| Oracle8i Supplied Packages Reference Release 8.1.5 A68001-01 |
|
DBMS_HS contains subprograms to set and unset Heterogeneous Services (HS) initialization parameters, capabilities, instance names, and class names.
This packages are installed by SYS (connect internal). The HS tables are created by CATHS.SQL and are owned by the system.
miss_base_caps exception; pragma exception_init(miss_base_caps, -24274); miss_base_caps_num number := -24274; dupl_base_caps exception; pragma exception_init(dupl_base_caps, -24270); dupl_base_caps_num number := -24270; dupl_base_caps_msg varchar2(76) := 'HS$_BASE_CAPS'; miss_base_dd exception; pragma exception_init(miss_base_dd, -24274); miss_base_dd_num number := -24274; miss_base_dd_msg varchar2(76) := 'HS$_BASE_DD'; dupl_base_dd exception; pragma exception_init(dupl_base_dd, -24270); dupl_base_dd_num number := -24270; dupl_base_dd_msg varchar2(76) := 'HS$_BASE_DD'; miss_external_object exception; pragma exception_init(miss_external_object, -24274); miss_external_object_num number := -24274; miss_external_object_msg varchar2(76) := 'HS$_EXTERNAL_OBJECTS'; dupl_external_object exception; pragma exception_init(dupl_external_object, -24270); dupl_external_object_num number := -24270; dupl_external_object_msg varchar2(76) := 'HS$_EXTERNAL_OBJECTS'; miss_granted_user exception; pragma exception_init(miss_granted_user, -24274); miss_granted_user_num number := -24274; miss_granted_user_msg varchar2(76) := 'HS$_GRANTED_USERS'; dupl_granted_user exception; pragma exception_init(dupl_granted_user, -24270); dupl_granted_user_num number := -24270; dupl_granted_user_msg varchar2(76) := 'HS$_GRANTED_USERS'; miss_access_grantee exception; pragma exception_init(miss_access_grantee, -24274); miss_access_grantee_num number := -24274; miss_access_grantee_msg varchar2(76) := 'HS$_ACCESS_GRANTEES'; dupl_access_grantee exception; pragma exception_init(dupl_access_grantee, -24270); dupl_access_grantee_num number := -24270; dupl_access_grantee_msg varchar2(76) := 'HS$_ACCESS_GRANTEES'; miss_create_grantee exception; pragma exception_init(miss_create_grantee, -24274); miss_create_grantee_num number := -24274; miss_create_grantee_msg varchar2(76) := 'HS$_CREATE_GRANTEES'; dupl_create_grantee exception; pragma exception_init(dupl_create_grantee, -24270); dupl_create_grantee_num number := -24270; dupl_create_grantee_msg varchar2(76) := 'HS$_CREATE_GRANTEES'; miss_privilege exception; pragma exception_init(miss_privilege, -24274); miss_privilege_num number := -24274; miss_privilege_msg varchar2(76) := 'HS$_PRIVILEGES'; dupl_privilege exception; pragma exception_init(dupl_privilege, -24270); dupl_privilege_num number := -24270; dupl_privilege_msg varchar2(76) := 'HS$_PRIVILEGES'; miss_class_caps exception; pragma exception_init(miss_class_caps, -24274); miss_class_caps_num number := -24274; miss_class_caps_msg varchar2(76) := 'HS$_CLASS_CAPS';
dupl_class_caps exception; pragma exception_init(dupl_class_caps, -24270); dupl_class_caps_num number := -24270; dupl_class_caps_msg varchar2(76) := 'HS$_CLASS_CAPS'; miss_class_dd exception; pragma exception_init(miss_class_dd, -24274); miss_class_dd_num number := -24274; miss_class_dd_msg varchar2(76) := 'HS$_CLASS_DD'; dupl_class_dd exception; pragma exception_init(dupl_class_dd, -24270); dupl_class_dd_num number := -24270; dupl_class_dd_msg varchar2(76) := 'HS$_CLASS_DD'; bad_TRANSLATION_TYPE exception; pragma exception_init(bad_TRANSLATION_TYPE, -24271); bad_TRANSLATION_TYPE_num number := -24271; bad_TRANSLATION_TYPE_msg varchar2(76) := 'NULL'; bad_TRANSLATION_TEXT exception; pragma exception_init(bad_TRANSLATION_TEXT, -24273); bad_TRANSLATION_TEXT_num number := -24273; bad_TRANSLATION_TEXT_msg varchar2(76) := 'NULL'; miss_class_init exception; pragma exception_init(miss_class_init, -24274); miss_class_init_num number := -24274; miss_class_init_msg varchar2(76) := 'HS$_CLASS_INIT'; dupl_class_init exception; pragma exception_init(dupl_class_init, -24270); dupl_class_init_num number := -24270; dupl_class_init_msg varchar2(76) := 'HS$_CLASS_INIT'; bad_INIT_VALUE_TYPE exception; pragma exception_init(bad_INIT_VALUE_TYPE, -24272); bad_INIT_VALUE_TYPE_num number := -24272; bad_INIT_VALUE_TYPE_msg varchar2(76) := 'NULL'; miss_fds_class exception; pragma exception_init(miss_fds_class, -24274); miss_fds_class_num number := -24274; miss_fds_class_msg varchar2(76) := 'HS$_FDS_CLASS'; dupl_fds_class exception; pragma exception_init(dupl_fds_class, -24270); dupl_fds_class_num number := -24270; dupl_fds_class_msg varchar2(76) := 'HS$_FDS_CLASS'; miss_fds_inst exception; pragma exception_init(miss_fds_inst, -24274); miss_fds_inst_num number := -24274; miss_fds_inst_msg varchar2(76) := 'HS$_FDS_INST'; dupl_fds_inst exception; pragma exception_init(dupl_fds_inst, -24270); dupl_fds_inst_num number := -24270; dupl_fds_inst_msg varchar2(76) := 'HS$_FDS_INST'; miss_inst_caps exception; pragma exception_init(miss_inst_caps, -24274); miss_inst_caps_num number := -24274; miss_inst_caps_msg varchar2(76) := 'HS$_INST_CAPS'; dupl_inst_caps exception; pragma exception_init(dupl_inst_caps, -24270); dupl_inst_caps_num number := -24270; dupl_inst_caps_msg varchar2(76) := 'HS$_INST_CAPS'; miss_inst_dd exception; pragma exception_init(miss_inst_dd, -24274); miss_inst_dd_num number := -24274; miss_inst_dd_msg varchar2(76) := 'HS$_INST_DD'; dupl_inst_dd exception; pragma exception_init(dupl_inst_dd, -24270); dupl_inst_dd_num number := -24270; dupl_inst_dd_msg varchar2(76) := 'HS$_INST_DD'; miss_inst_init exception; pragma exception_init(miss_inst_init, -24274); miss_inst_init_num number := -24274; miss_inst_init_msg varchar2(76) := 'HS$_INST_INIT'; dupl_inst_init exception; pragma exception_init(dupl_inst_init, -24270); dupl_inst_init_num number := -24270; dupl_inst_init_msg varchar2(76) := 'HS$_INST_INIT'; no_privilege exception; pragma exception_init(no_privilege, -24277); no_privilege_num number := -24277; no_privilege_msg varchar2(76) := null; privilege_mismatch exception; pragma exception_init(privilege_mismatch, -24278); privilege_mismatch_num number := -24278; privilege_mismatch_msg varchar2(76) := null; lib_priv_mismatch exception; pragma exception_init(lib_priv_mismatch, -24279); lib_priv_mismatch_num number := -24279; lib_priv_mismatch_msg varchar2(76) := null;
| Subprogram | Description |
|---|---|
ALTER_BASE_CAPS procedure |
Alters a row in the |
ALTER_BASE_DD procedure |
Alters a row in the |
ALTER_CLASS_CAPS procedure |
Alters the contents of the |
ALTER_CLASS_DD procedure |
Modifies the contents of the |
ALTER_CLASS_INIT procedure |
Alters the contents of the |
ALTER_FDS_CLASS procedure |
Alters the contents of the |
ALTER_FDS_INST procedure |
Modifies the contents of the |
ALTER_INST_CAPS procedure |
Modifies the contents of the |
ALTER_INST_DD procedure |
Alters the contents of the |
ALTER_INST_INIT procedure |
Alters the contents of the |
COPY_CLASS procedure |
Copies everything for a class to another class. |
COPY_INST procedure |
Copies everything for an |
CREATE_BASE_CAPS procedure |
Creates a row in the |
CREATE_BASE_CAPS procedure |
Creates a row in the |
CREATE_BASE_DD procedure |
Creates a row in the |
CREATE_CLASS_CAPS procedure |
Creates a row in the |
CREATE_CLASS_DD procedure |
Creates a row in the |
CREATE_CLASS_INIT procedure |
Creates a row in the |
CREATE_FDS_CLASS procedure |
Creates a row in the |
CREATE_FDS_INST procedure |
Creates a row in the |
CREATE_INST_CAPS procedure |
Creates a row in the |
CREATE_INST_DD procedure |
Creates a row in the |
CREATE_INST_INIT procedure |
Creates a row in the |
DROP_BASE_CAPS procedure |
Drops a row from the |
DROP_BASE_DD procedure |
Drops a row from the |
DROP_CLASS_CAPS procedure |
Deletes a row from the |
DROP_CLASS_DD procedure |
Deletes row in |
DROP_CLASS_INIT procedure |
Drops row in |
DROP_FDS_CLASS procedure |
Drops row in |
DROP_FDS_INST procedure |
Drops row in |
DROP_INST_CAPS procedure |
Deletes rows in |
DROP_INST_DD procedure |
Drops rows from |
DROP_INST_INIT procedure |
Drops rows from |
REPLACE_BASE_CAPS procedure |
Creates or replaces a row in the |
REPLACE_BASE_DD procedure |
Creates or replaces a row in the |
REPLACE_CLASS_CAPS procedure |
Performs a create or replace on the |
REPLACE_CLASS_DD procedure |
Performs a create or replace on the |
REPLACE_CLASS_INIT procedure |
Creates or updates a row in the |
REPLACE_FDS_CLASS procedure |
Performs create or replace operations on the |
REPLACE_FDS_INST procedure |
Creates or replaces rows in the |
REPLACE_INST_CAPS procedure |
Performs a create or replace on the |
REPLACE_INST_DD procedure |
Performs a create or replace operation on the |
REPLACE_INST_INIT procedure |
Performs a create or replace on the |
This procedure alters a row in the HS$_BASE_CAPS table.
DBMS_HS.ALTER_BASE_CAPS ( CAP_NUMBER IN NUMBER, new_CAP_NUMBER IN NUMBER := -1e-130, new_CAP_DESCRIPTION IN VARCHAR2 := '-');
This procedure alters a row in the HS$_BASE_DD table.
DBMS_HS.ALTER_BASE_DD ( DD_TABLE_NAME IN VARCHAR2, new_DD_TABLE_NAME IN VARCHAR2 := '-', new_DD_TABLE_DESC IN VARCHAR2 := '-');
This procedure alters the contents of the HS$_CLASS_CAPS table.
DBMS_HS.ALTER_CLASS_CAPS( FDS_CLASS_NAME IN VARCHAR2, CAP_NUMBER IN NUMBER, new_FDS_CLASS_NAME IN VARCHAR2 := '-', new_CAP_NUMBER IN NUMBER := -1e-130, new_CONTEXT IN NUMBER := -1e-130, new_TRANSLATION IN VARCHAR2 := '-', new_ADDITIONAL_INFO IN NUMBER := -1e-130);
This procedure modifies the contents of the HS$_CLASS_DD table.
DBMS_HS.ALTER_CLASS_DD ( FDS_CLASS_NAME IN VARCHAR2, DD_TABLE_NAME IN VARCHAR2, new_FDS_CLASS_NAME IN VARCHAR2 := '-', new_DD_TABLE_NAME IN VARCHAR2 := '-', new_TRANSLATION_TYPE IN CHAR := '-', new_TRANSLATION_TEXT IN VARCHAR2 := '-');
This procedure alters the contents of the HS$_CLASS_INIT table.
DBMS_HS.ALTER_CLASS_INIT ( FDS_CLASS_NAME IN VARCHAR2, INIT_VALUE_NAME IN VARCHAR2, new_FDS_CLASS_NAME IN VARCHAR2 := '-', new_INIT_VALUE_NAME IN VARCHAR2 := '-', new_INIT_VALUE IN VARCHAR2 := '-', new_INIT_VALUE_TYPE IN VARCHAR2 := '-');
This procedure alters the contents of the HS$_FDS_CLASS table.
DBMS_HS.ALTER_FDS_CLASS( FDS_CLASS_NAME IN VARCHAR2, new_FDS_CLASS_NAME IN VARCHAR2 := '-', new_FDS_CLASS_COMMENTS IN VARCHAR2 := '-');
This procedure modifies the contents of the HS$_FDS_INST table.
DBMS_HS.ALTER_FDS_INST ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2, new_FDS_INST_NAME IN VARCHAR2 := '-', new_FDS_CLASS_NAME IN VARCHAR2 := '-', new_FDS_INST_COMMENTS IN VARCHAR2 := '-');
This procedure modifies the contents of the $HS_INST_CAPS table.
DBMS_HS.ALTER_INST_CAPS ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2, CAP_NUMBER IN NUMBER, new_FDS_INST_NAME IN VARCHAR2 := '-', new_FDS_CLASS_NAME IN VARCHAR2 := '-', new_CAP_NUMBER IN NUMBER := -1e-130, new_CONTEXT IN NUMBER := -1e-130, new_TRANSLATION IN VARCHAR2 := '-', new_ADDITIONAL_INFO IN NUMBER := -1e-130);
This procedure alters the contents of the HS$_INST_DD table.
DBMS_HS.ALTER_INST_DD ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2, DD_TABLE_NAME IN VARCHAR2, new_FDS_INST_NAME IN VARCHAR2 := '-', new_FDS_CLASS_NAME IN VARCHAR2 := '-', new_DD_TABLE_NAME IN VARCHAR2 := '-', new_TRANSLATION_TYPE IN CHAR := '-', new_TRANSLATION_TEXT IN VARCHAR2 := '-');
This procedure alters the contents of the HS$_INST_INIT table.
DBMS_HS.ALTER_INST_INIT ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2, INIT_VALUE_NAME IN VARCHAR2, new_FDS_INST_NAME IN VARCHAR2 := '-', new_FDS_CLASS_NAME IN VARCHAR2 := '-', new_INIT_VALUE_NAME IN VARCHAR2 := '-', new_INIT_VALUE IN VARCHAR2 := '-', new_INIT_VALUE_TYPE IN VARCHAR2 := '-');
This procedure copies everything for a class to another class.
DBMS_HS.COPY_CLASS ( old_fds_class_name VARCHAR2,
This procedure copies everything for an HS$_FDS_INST to a new instance in the same FDS_CLASS.
DBMS_HS.COPY_INST ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2, new_FDS_INST_NAME IN VARCHAR2, new_FDS_COMMENTS IN VARCHAR2 default '-');
This procedure creates a row in the HS$_BASE_CAPS table.
DBMS_HS.CREATE_BASE_CAPS ( CAP_NUMBER IN NUMBER, CAP_DESCRIPTION IN VARCHAR2 := NULL);
This procedure creates a row in the HS$_BASE_DD table.
DBMS_HS.CREATE_BASE_DD ( DD_TABLE_NAME IN VARCHAR2, DD_TABLE_DESC IN VARCHAR2 := NULL);
This procedure creates a row in the HS$_CLASS_CAPS table.
The FDS_CLASS_NAME must be exist in the HS$_FDS_CLASS table. The CAP_NUMBER must be defined in the HS$_BASE_CAPS table.
DBMS_HS.CREATE_CLASS_CAPS ( FDS_CLASS_NAME IN VARCHAR2, CAP_NUMBER IN NUMBER, CONTEXT IN NUMBER := NULL, TRANSLATION IN VARCHAR2 := NULL, ADDITIONAL_INFO IN NUMBER := NULL);
This procedure creates a row in the HS$_CLASS_DD table.
The FDS_CLASS_NAME must exist in the HS$_FDS_CLASS table. The DD_TABLE_NAME must exist in the HS$_BASE_DD table. TRANSLATION_TYPE must be either 'T' (translated) or 'M' (mimicked). If TRANSLATION_TYPE = 'T', then the TRANSLATION_TEXT string must be supplied.
DBMS_HS.CREATE_CLASS_DD ( FDS_CLASS_NAME IN VARCHAR2, DD_TABLE_NAME IN VARCHAR2, TRANSLATION_TYPE IN CHAR, TRANSLATION_TEXT IN VARCHAR2 := NULL);
This procedure creates a row in the HS$_CLASS_INIT table.
The FDS_CLASS_NAME must exist in the HS$_FDS_CLASS table. The INIT_VALUE_TYPE must either 'F' (environment variable) or 'M' (not an environment variable).
DBMS_HS.CREATE_CLASS_INIT ( FDS_CLASS_NAME IN VARCHAR2, INIT_VALUE_NAME IN VARCHAR2, INIT_VALUE IN VARCHAR2, INIT_VALUE_TYPE IN VARCHAR2);
This procedure creates a row in the HS$_FDS_CLASS table.
DBMS_HS.CREATE_FDS_CLASS ( FDS_CLASS_NAME IN VARCHAR2, FDS_CLASS_COMMENTS IN VARCHAR2 := NULL);
This procedure creates a row in the HS$_FDS_INST table.
The FDS_CLASS_NAME must exist in the HS$_FDS_CLASS table.
DBMS_HS.CREATE_FDS_INST ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2, FDS_INST_COMMENTS IN VARCHAR2 := NULL);
This procedure creates a row in the HS$_INST_CAPS table.
The FDS_INST_NAME must exist in the HS$_FDS_INST table and be defined for the row in HS$_FDS_CLASS specified by the FDS_CLASS_NAME row. The CAP_NUMBER must be defined in the HS$_BASE_CAPS table.
DBMS_HS.CREATE_INST_CAPS ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2, CAP_NUMBER IN NUMBER, CONTEXT IN NUMBER := NULL, TRANSLATION IN VARCHAR2 := NULL, ADDITIONAL_INFO IN NUMBER := NULL);
This procedure creates a row in the HS$_INST_DD table.
The FDS_INST_NAME must be defined in the HS$_FDS_INST table and must belong to the FDS_CLASS specified by the HS$_FDS_CLASS parameter. The DD_TABLE_NAME must be defined in the HS$_BASE_DD table. TRANSLATION_TYPE must be either 'T' (translated) or 'M' (mimicked). If TRANSLATION_TYPE is 'T', then TRANSLATION_TEXT must be supplied.
DBMS_HS.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 := NULL);
This procedure creates a row in the HS$_INST_INIT table.
The FDS_INST_NAME must exist in the HS$_FDS_INST table and must be exist in the HS$_FDS_CLASS table as specified by the FDS_CLASS_NAME parameter. The INIT_VALUE_TYPE must be defined either 'F' or 'T'.
DBMS_HS.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);
This procedure drops a row from the HS$_BASE_CAPS table as specified by the CAP_NUMBER parameter.
DBMS_HS.DROP_BASE_CAPS ( CAP_NUMBER IN NUMBER);
This procedure drops a row from the HS$_BASE_DD table as specified by table_name.
DBMS_HS.DROP_BASE_DD ( DD_TABLE_NAME IN VARCHAR2);
This procedure deletes a row from the HS$_CLASS_CAPS table as specified by the FDS_CLASS_NAME and CAP_NUMBER.
DBMS_HS.DROP_CLASS_CAPS ( FDS_CLASS_NAME IN VARCHAR2, CAP_NUMBER IN NUMBER);
This procedure deletes rows in HS$_CLASS_DD specified by FDS_CLASS_NAME and DD_TABLE_NAME.
DBMS_HS.DROP_CLASS_DD( FDS_CLASS_NAME IN VARCHAR2, DD_TABLE_NAME IN VARCHAR2);
Drops row in HS$_CLASS_INIT as specified by FDS_CLASS_NAME and INIT_VALUE_NAME.
DBMS_HS.DROP_CLASS_INIT ( FDS_CLASS_NAME IN VARCHAR2, INIT_VALUE_NAME IN VARCHAR2);
This procedure drops rows in HS$_FDS_CLASS as specified by FDS_CLASS_NAME;
DBMS_HS.DROP_FDS_CLASS ( FDS_CLASS_NAME IN VARCHAR2);
This procedure drops rows in HS$_FDS_INST table as specified by FDS_INST_NAME and FDS_CLASS_NAME.
DBMS_HS.DROP_FDS_INST ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2);
This procedure deletes rows in HS$_INST_CAPS specified by FDS_INST_NAME, FDS_CLASS_NAME and CAP_NUMBER.
DBMS_HS.DROP_INST_CAPS ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2, CAP_NUMBER IN NUMBER);
This procedure drops rows from HS$_INST_DD specified by FDS_INST_NAME, FDS_CLASS_NAME and DD_TABLE_NAME.
DBMS_HS.DROP_INST_DD ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2, DD_TABLE_NAME IN VARCHAR2);
Drops rows from HS$_INST_INIT table as specified by FDS_INST_NAME, FDS_CLASS_NAME, and INIT_VALUE_NAME.
DBMS_HS.DROP_INST_INIT ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2, INIT_VALUE_NAME IN VARCHAR2); new_fds_class_name VARCHAR2, new_fds_class_comments VARCHAR2 default '-');
This procedure creates or replaces a row in the HS$_BASE_CAPS table.
It first attempts to update the row in HS$_BASE_CAPS. If the row does not exist, then it attempts to insert the row. The new_CAP_NUMBER parameter is ignored if the row specified by CAP_NUMBER does not exist.
DBMS_HS.REPLACE_BASE_CAPS ( CAP_NUMBER IN NUMBER, new_CAP_NUMBER IN NUMBER := NULL, new_CAP_DESCRIPTION IN VARCHAR2 := NULL);
This procedure does a create or replace on a row in the HS$_BASE_DD table.
First, this procedure attempts to update the row. If the row does not exist, then it is inserted, and the new_DD_TABLE_NAME parameter is ignored.
DBMS_HS.REPLACE_BASE_DD ( DD_TABLE_NAME IN VARCHAR2, new_DD_TABLE_NAME IN VARCHAR2 := NULL, new_DD_TABLE_DESC IN VARCHAR2 := NULL);
This procedure does a 'create or replace' on the HS$_CLASS_CAPS table.
If a row exists for the FDS_CLASS_NAME and CAP_NUMBER, then it is updated. If a row does not exist, then it is inserted, and the new_FDS_CLASS_NAME and new_CAP_NUMBER parameters are ignored.
DBMS_HS.REPLACE_CLASS_CAPS ( FDS_CLASS_NAME IN VARCHAR2, CAP_NUMBER IN NUMBER, new_FDS_CLASS_NAME IN VARCHAR2 := NULL, new_CAP_NUMBER IN NUMBER := NULL, new_CONTEXT IN NUMBER := NULL, new_TRANSLATION IN VARCHAR2 := NULL, new_ADDITIONAL_INFO IN NUMBER := NULL);
This procedure performs a 'create or replace' on the HS$_CLASS_DD table.
If a row exists for the FDS_CLASS_NAME and DD_TABLE_NAME, then the row is updated. If a row does not exist, then it is inserted, and the new_FDS_CLASS_NAME and new_DD_TABLE_NAME parameters are ignored.
DBMS_HS.REPLACE_CLASS_DD ( FDS_CLASS_NAME IN VARCHAR2, DD_TABLE_NAME IN VARCHAR2, new_FDS_CLASS_NAME IN VARCHAR2 := NULL, new_DD_TABLE_NAME IN VARCHAR2 := NULL, new_TRANSLATION_TYPE IN CHAR := NULL, new_TRANSLATION_TEXT IN VARCHAR2 := NULL);
This procedure creates or updates a row in the HS$_CLASS_INIT table.
If a row exists with the specified FDS_CLASS_NAME and INIT_VALUE_NAME, then it is updated. If the row does not exist, then it is inserted, and the new_FDS_CLASS_NAME and new_INIT_VALUE_NAME parameters are ignored.
DBMS_HS.REPLACE_CLASS_INIT ( FDS_CLASS_NAME IN VARCHAR2, INIT_VALUE_NAME IN VARCHAR2, new_FDS_CLASS_NAME IN VARCHAR2 := NULL, new_INIT_VALUE_NAME IN VARCHAR2 := NULL, new_INIT_VALUE IN VARCHAR2 := NULL, new_INIT_VALUE_TYPE IN VARCHAR2 := NULL);
This procedure does create or replace operations on the HS$_FDS_CLASS table.
If a row exists for the FDS_CLASS_NAME, then it is updated. If no row exists, then it is created, and the new_FDS_CLASS_NAME parameter is ignored.
DBMS_HS.REPLACE_FDS_CLASS ( FDS_CLASS_NAME IN VARCHAR2, new_FDS_CLASS_NAME IN VARCHAR2 := NULL, new_FDS_CLASS_COMMENTS IN VARCHAR2 := NULL);
This procedure creates or replaces rows in the HS$_FDS_INST table.
If a row exists for the FDS_INST_NAME and FDS_CLASS_NAME, then it is updated. If no row exists, then it is created, and the new_FDS_INST_NAME and new_FDS_CLASS_NAME parameters are ignored when performing the insert.
DBMS_HS.REPLACE_FDS_INST ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2, new_FDS_INST_NAME IN VARCHAR2 := NULL, new_FDS_CLASS_NAME IN VARCHAR2 := NULL, new_FDS_INST_COMMENTS IN VARCHAR2 := NULL);
This procedure does a create or replace on the HS$_INST_CAPS table.
If no row exists for the FDS_INST_NAME, FDS_CLASS_NAME and CAP_NUMBER, then the row is created. If a row exists, then it is updated. In the case where an insert is performed, the new_FDS_INST_NAME, new_FDS_CLASS_NAME and new_CLASS_NUMBER parameters are ignored.
DBMS_HS.REPLACE_INST_CAPS ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2, CAP_NUMBER IN NUMBER, new_FDS_INST_NAME IN VARCHAR2 := NULL, new_FDS_CLASS_NAME IN VARCHAR2 := NULL, new_CAP_NUMBER IN NUMBER := NULL, new_CONTEXT IN NUMBER := NULL, new_TRANSLATION IN VARCHAR2 := NULL, new_ADDITIONAL_INFO IN NUMBER := NULL);
This procedure performs a create or replace operation on the HS$_INST_DD table.
If a row exists for the FDS_INST_NAME, FDS_CLASS_NAME and DD_TABLE_NAME, then it is updated. If no row exists, then it is created, and the new_FDS_INST_NAME, new_FDS_CLASS_NAME, and new_DD_TABLE_NAME values are ignored.
DBMS_HS.REPLACE_INST_DD ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2, DD_TABLE_NAME IN VARCHAR2, new_FDS_INST_NAME IN VARCHAR2 := NULL, new_FDS_CLASS_NAME IN VARCHAR2 := NULL, new_DD_TABLE_NAME IN VARCHAR2 := NULL, new_TRANSLATION_TYPE IN CHAR := NULL, new_TRANSLATION_TEXT IN VARCHAR2 := NULL);
This procedure performs a create or replace on the HS$_INST_INIT table.
If a row exists with the FDS_INST_NAME, FDS_CLASS_NAME and INIT_VALUE_NAME, then it is updated. If a row does not exist, then it is created. In the creation case, the new_FDS_INST_NAME, new_FDS_CLASS_NAME and new_INIT_VALUE_NAME are ignored.
DBMS_HS.REPLACE_INST_INIT ( FDS_INST_NAME IN VARCHAR2, FDS_CLASS_NAME IN VARCHAR2, INIT_VALUE_NAME IN VARCHAR2, new_FDS_INST_NAME IN VARCHAR2 := NULL, new_FDS_CLASS_NAME IN VARCHAR2 := NULL, new_INIT_VALUE_NAME IN VARCHAR2 := NULL, new_INIT_VALUE IN VARCHAR2 := NULL, new_INIT_VALUE_TYPE IN VARCHAR2 := NULL);
