DBMS_HS, 2 of 2

Summary of Subprograms

Table 14-1 DBMS_HS Package Subprograms

Subprogram	Description
ALTER_BASE_CAPS Procedure	Alters a row in the `HS$_BASE_CAPS` table.
ALTER_BASE_DD Procedure	Alters a row in the `HS$_BASE_DD` table.
ALTER_CLASS_CAPS Procedure	Alters the contents of the `HS$_CLASS_CAPS` table.
ALTER_CLASS_DD Procedure	Modifies the contents of the `HS$_CLASS_DD` table.
ALTER_CLASS_INIT Procedure	Alters the contents of the `HS$_CLASS_INIT` table.
ALTER_FDS_CLASS Procedure	Alters the contents of the `HS$_FDS_CLASS` table.
ALTER_FDS_INST Procedure	Modifies the contents of the `HS$_FDS_INST` table.
ALTER_INST_CAPS Procedure	Modifies the contents of the `$HS_INST_CAPS` table.
ALTER_INST_DD Procedure	Alters the contents of the `HS$_INST_DD` table.
ALTER_INST_INIT Procedure	Alters the contents of the `HS$_INST_INIT` table.
COPY_CLASS Procedure	Copies everything for a class to another class.
COPY_INST Procedure	Copies everything for an `HS$_FDS_INST` to a new instance in the same `FDS_CLASS`.
CREATE_BASE_CAPS Procedure	Creates a row in the `HS$_BASE_CAPS` table.
CREATE_BASE_CAPS Procedure	Creates a row in the `HS$_BASE_DD` table.
CREATE_BASE_DD Procedure	Creates a row in the `HS$_BASE_DD` table.
CREATE_CLASS_CAPS Procedure	Creates a row in the `HS$_CLASS_CAPS` table.
CREATE_CLASS_DD Procedure	Creates a row in the `HS$_CLASS_DD` table.
CREATE_CLASS_INIT Procedure	Creates a row in the `HS$_CLASS_INIT` table.
CREATE_FDS_CLASS Procedure	Creates a row in the `HS$_FDS_CLASS` table.
CREATE_FDS_INST Procedure	Creates a row in the `HS$_FDS_INST` table.
CREATE_INST_CAPS Procedure	Creates a row in the `HS$_INST_CAPS` table.
CREATE_INST_DD Procedure	Creates a row in the `HS$_INST_DD` table.
CREATE_INST_INIT Procedure	Creates a row in the `HS$_INST_INIT` table.
DROP_BASE_CAPS Procedure	Drops a row from the `HS$_BASE_CAPS` table as specified by the `CAP_NUMBER` parameter.
DROP_BASE_DD Procedure	Drops a row from the `HS$_BASE_DD` table as specified by `table_name`.
DROP_CLASS_CAPS Procedure	Deletes a row from the `HS$_CLASS_CAPS` table as specified by the `FDS_CLASS_NAME` and `CAP_NUMBER`.
DROP_CLASS_DD Procedure	Deletes row in `HS$_CLASS_DD` specified by `FDS_CLASS_NAME` and `DD_TABLE_NAME`.
DROP_CLASS_INIT Procedure	Drops row in `HS$_CLASS_INIT` as specified by `FDS_CLASS_NAME` and `INIT_VALUE_NAME`.
DROP_FDS_CLASS Procedure	Drops row in `HS$_FDS_CLASS` as specified by `FDS_CLASS_NAME`.
DROP_FDS_INST Procedure	Drops row in `HS$_FDS_INST` table as specified by `FDS_INST_NAME` and `FDS_CLASS_NAME`.
DROP_INST_CAPS Procedure	Deletes rows in `HS$_INST_CAPS` specified by `FDS_INST_NAME`, `FDS_CLASS_NAME` and `CAP_NUMBER`.
DROP_INST_DD Procedure	Drops rows from `HS$_INST_DD` specified by `FDS_INST_NAME`, `FDS_CLASS_NAME` and `DD_TABLE_NAME`.
DROP_INST_INIT Procedure	Drops rows from `HS$_INST_INIT` table as specified by `FDS_INST_NAME`, `FDS_CLASS_NAME`, and `INIT_VALUE_NAME`.
REPLACE_BASE_CAPS Procedure	Creates or replaces a row in the `HS$_BASE_CAPS` table.
REPLACE_BASE_DD Procedure	Creates or replaces a row in the `HS$_BASE_DD` table.
REPLACE_CLASS_CAPS Procedure	Performs a create or replace on the `HS$_CLASS_CAPS` table.
REPLACE_CLASS_DD Procedure	Performs a create or replace on the `HS$_CLASS_DD` table.
REPLACE_CLASS_INIT Procedure	Creates or updates a row in the `HS$_CLASS_INIT` table.
REPLACE_FDS_CLASS Procedure	Performs create or replace operations on the `HS$_FDS_CLASS` table.
REPLACE_FDS_INST Procedure	Creates or replaces rows in the `HS$_FDS_INST` table.
REPLACE_INST_CAPS Procedure	Performs a create or replace on the `HS$_INST_CAPS` table.
REPLACE_INST_DD Procedure	Performs a create or replace operation on the `HS$_INST_DD` table.
REPLACE_INST_INIT Procedure	Performs a create or replace on the `HS$_INST_INIT` table.

ALTER_BASE_CAPS Procedure

This procedure alters a row in the HS$_BASE_CAPS table.

Syntax

DBMS_HS.ALTER_BASE_CAPS (          
   CAP_NUMBER          IN NUMBER,             
   new_CAP_NUMBER      IN NUMBER   := -1e-130,        
   new_CAP_DESCRIPTION IN VARCHAR2 := '-');

ALTER_BASE_DD Procedure

This procedure alters a row in the HS$_BASE_DD table.

Syntax

DBMS_HS.ALTER_BASE_DD (            
   DD_TABLE_NAME     IN VARCHAR2,        
   new_DD_TABLE_NAME IN VARCHAR2 := '-',       
   new_DD_TABLE_DESC IN VARCHAR2 := '-');

ALTER_CLASS_CAPS Procedure

This procedure alters the contents of the HS$_CLASS_CAPS table.

Syntax

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

ALTER_CLASS_DD Procedure

This procedure modifies the contents of the HS$_CLASS_DD table.

Syntax

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

ALTER_CLASS_INIT Procedure

This procedure alters the contents of the HS$_CLASS_INIT table.

Syntax

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

ALTER_FDS_CLASS Procedure

This procedure alters the contents of the HS$_FDS_CLASS table.

Syntax

DBMS_HS.ALTER_FDS_CLASS(          
   FDS_CLASS_NAME         IN VARCHAR2,       
   new_FDS_CLASS_NAME     IN VARCHAR2 := '-',      
   new_FDS_CLASS_COMMENTS IN VARCHAR2 := '-');

ALTER_FDS_INST Procedure

This procedure modifies the contents of the HS$_FDS_INST table.

Syntax

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

ALTER_INST_CAPS Procedure

This procedure modifies the contents of the $HS_INST_CAPS table.

Syntax

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

ALTER_INST_DD Procedure

This procedure alters the contents of the HS$_INST_DD table.

Syntax

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

ALTER_INST_INIT Procedure

This procedure alters the contents of the HS$_INST_INIT table.

Syntax

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

COPY_CLASS Procedure

This procedure copies everything for a class to another class.

Syntax

DBMS_HS.COPY_CLASS ( 
   old_fds_class_name VARCHAR2,

COPY_INST Procedure

This procedure copies everything for an HS$_FDS_INST to a new instance in the same FDS_CLASS.

Syntax

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

CREATE_BASE_CAPS Procedure

This procedure creates a row in the HS$_BASE_CAPS table.

Syntax

DBMS_HS.CREATE_BASE_CAPS (         
   CAP_NUMBER      IN NUMBER,             
   CAP_DESCRIPTION IN VARCHAR2 := NULL);

CREATE_BASE_DD Procedure

This procedure creates a row in the HS$_BASE_DD table.

Syntax

DBMS_HS.CREATE_BASE_DD (           
   DD_TABLE_NAME IN VARCHAR2,        
   DD_TABLE_DESC IN VARCHAR2 := NULL);

CREATE_CLASS_CAPS Procedure

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.

Syntax

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

CREATE_CLASS_DD Procedure

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.

Syntax

DBMS_HS.CREATE_CLASS_DD (          
   FDS_CLASS_NAME   IN VARCHAR2,       
   DD_TABLE_NAME    IN VARCHAR2,        
   TRANSLATION_TYPE IN CHAR,         
   TRANSLATION_TEXT IN VARCHAR2 := NULL);

CREATE_CLASS_INIT Procedure

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

Syntax

DBMS_HS.CREATE_CLASS_INIT (        
   FDS_CLASS_NAME  IN VARCHAR2,       
   INIT_VALUE_NAME IN VARCHAR2,      
   INIT_VALUE      IN VARCHAR2,           
   INIT_VALUE_TYPE IN VARCHAR2);

CREATE_FDS_CLASS Procedure

This procedure creates a row in the HS$_FDS_CLASS table.

Syntax

DBMS_HS.CREATE_FDS_CLASS (         
   FDS_CLASS_NAME     IN VARCHAR2,       
   FDS_CLASS_COMMENTS IN VARCHAR2 := NULL);

CREATE_FDS_INST Procedure

This procedure creates a row in the HS$_FDS_INST table.

The FDS_CLASS_NAME must exist in the HS$_FDS_CLASS table.

Syntax

DBMS_HS.CREATE_FDS_INST (          
   FDS_INST_NAME     IN VARCHAR2,        
   FDS_CLASS_NAME    IN VARCHAR2,       
   FDS_INST_COMMENTS IN VARCHAR2 := NULL);

CREATE_INST_CAPS Procedure

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.

Syntax

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

CREATE_INST_DD Procedure

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.

Syntax

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

CREATE_INST_INIT Procedure

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

Syntax

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

DROP_BASE_CAPS Procedure

This procedure drops a row from the HS$_BASE_CAPS table as specified by the CAP_NUMBER parameter.

Syntax

DBMS_HS.DROP_BASE_CAPS (           
   CAP_NUMBER IN NUMBER);

DROP_BASE_DD Procedure

This procedure drops a row from the HS$_BASE_DD table as specified by table_name.

Syntax

DBMS_HS.DROP_BASE_DD (             
   DD_TABLE_NAME IN VARCHAR2);

DROP_CLASS_CAPS Procedure

This procedure deletes a row from the HS$_CLASS_CAPS table as specified by the FDS_CLASS_NAME and CAP_NUMBER.

Syntax

DBMS_HS.DROP_CLASS_CAPS (          
   FDS_CLASS_NAME IN VARCHAR2,       
   CAP_NUMBER     IN NUMBER);

DROP_CLASS_DD Procedure

This procedure deletes rows in HS$_CLASS_DD specified by FDS_CLASS_NAME and DD_TABLE_NAME.

Syntax

DBMS_HS.DROP_CLASS_DD(            
   FDS_CLASS_NAME IN VARCHAR2,       
   DD_TABLE_NAME  IN VARCHAR2);

DROP_CLASS_INIT Procedure

Drops row in HS$_CLASS_INIT as specified by FDS_CLASS_NAME and INIT_VALUE_NAME.

Syntax

DBMS_HS.DROP_CLASS_INIT (          
   FDS_CLASS_NAME  IN VARCHAR2,       
   INIT_VALUE_NAME IN VARCHAR2);

DROP_FDS_CLASS Procedure

This procedure drops rows in HS$_FDS_CLASS as specified by FDS_CLASS_NAME;

Syntax

DBMS_HS.DROP_FDS_CLASS (           
    FDS_CLASS_NAME IN VARCHAR2);

DROP_FDS_INST Procedure

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

DROP_INST_CAPS Procedure

This procedure deletes rows in HS$_INST_CAPS specified by FDS_INST_NAME, FDS_CLASS_NAME and CAP_NUMBER.

Syntax

DBMS_HS.DROP_INST_CAPS (           
   FDS_INST_NAME  IN VARCHAR2,        
   FDS_CLASS_NAME IN VARCHAR2,       
   CAP_NUMBER     IN NUMBER);

DROP_INST_DD Procedure

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

DROP_INST_INIT Procedure

Drops rows from HS$_INST_INIT table as specified by FDS_INST_NAME, FDS_CLASS_NAME, and INIT_VALUE_NAME.

Syntax

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

REPLACE_BASE_CAPS Procedure

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.

Syntax

DBMS_HS.REPLACE_BASE_CAPS (          
   CAP_NUMBER          IN NUMBER,             
   new_CAP_NUMBER      IN NUMBER   := NULL,        
   new_CAP_DESCRIPTION IN VARCHAR2 := NULL);

REPLACE_BASE_DD Procedure

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.

Syntax

DBMS_HS.REPLACE_BASE_DD (            
   DD_TABLE_NAME     IN VARCHAR2,        
   new_DD_TABLE_NAME IN VARCHAR2 := NULL,       
   new_DD_TABLE_DESC IN VARCHAR2 := NULL);

REPLACE_CLASS_CAPS Procedure

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.

Syntax

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

REPLACE_CLASS_DD Procedure

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.

Syntax

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

REPLACE_CLASS_INIT Procedure

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.

Syntax

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

REPLACE_FDS_CLASS Procedure

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.

Syntax

DBMS_HS.REPLACE_FDS_CLASS (          
   FDS_CLASS_NAME         IN VARCHAR2,       
   new_FDS_CLASS_NAME     IN VARCHAR2 := NULL,      
   new_FDS_CLASS_COMMENTS IN VARCHAR2 := NULL);

REPLACE_FDS_INST Procedure

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.

Syntax

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

REPLACE_INST_CAPS Procedure

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.

Syntax

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

REPLACE_INST_DD Procedure

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.

Syntax

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

REPLACE_INST_INIT Procedure

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.

Syntax

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