Oracle8i Distributed Database Systems
Release 8.1.5

A67784-01

Library

Product

Contents

Index

Prev Next

B
DBMS_HS Package Reference

This appendix provides all the interface information for the DBMS_HS package for administering Heterogeneous Services. See Chapter 6, "Administering Oracle Heterogeneous Services" for more information about administering the Heterogeneous Services.

Referenced in this appendix are:

DBMS_HS.CREATE_FDS_INST

Purpose

To register an instance of the non-Oracle system in the Oracle8i server. This is the logical name of the non-Oracle system instance, as know by Heterogeneous Services. Information about registered instances is available through the view HS_FDS_INST.

Interface description

PROCEDURE create_fds_inst( 
FDS_INST_NAME     IN VARCHAR2,
FDS_CLASS_NAME    IN VARCHAR2,
FDS_INST_COMMENTS IN VARCHAR2 )

Parameters and Descriptions
Parameter  Description 

FDS_INST_NAME  

Non-Oracle system instance to be registered in the Oracle8i server  

FDS_CLASS_NAME  

The class associated with the non-Oracle system instance.  

FDS_INST_COMMENTS  

Provides up to 255 bytes to describe the instance of the non-Oracle system.  

Exceptions
Exception  Description 

ORA-24270  

The instance already exists  

ORA-24274  

The object could not be created. Did you pass an existing CLASS or INSTANCE name?  

See Also

DBMS_HS.DROP_FDS_INST

DBMS_HS.CREATE_INST_INIT

Purpose

To create an initialization variable for an instance of the non-Oracle system. See Chapter 6, "Administering Oracle Heterogeneous Services" for more information on how to create initialization variables. See Appendix A, "Heterogeneous Services Initialization Parameters" for possible initialization parameters that can be set. The information will be available through the view HS_INST_INIT.

Interface description

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

Parameters and Descriptions
Parameter  Description 

FDS_INST_NAME  

Non-Oracle system instance for which the initialization parameter needs to be applied.  

FDS_CLASS_NAME  

The class associated with the non-Oracle system instance.  

INIT_VALUE_NAME  

Name of the initialization parameters. See Appendix A, "Heterogeneous Services Initialization Parameters" for possible values.  

INIT_VALUE  

Value of the initialization parameter  

INIT_VALUE_TYPE  

Must be

  • 'T' if initialization parameter must be set as an environment variable of the agent process

  • 'F' for a regular initialization parameter (default)

 

Exceptions
Exception  Description 

ORA-24270  

The initialization parameter is already defined for this instance  

ORA-24272  

The INIT_VALUE_TYPE is not 'T' or 'F'.  

ORA-24274  

The initialization parameter could not be created. Did you pass an existing CLASS or INSTANCE name?  

See Also

DBMS_HS.DROP_INST_INIT

DBMS_HS.DROP_FDS_INST

Purpose

To unregister a non-Oracle system instance. The view HS_FDS_INST contains information about registered instances.

Interface Description

PROCEDURE drop_fds_inst( 
FDS_INST_NAME  IN VARCHAR2,
FDS_CLASS_NAME IN VARCHAR2)

Parameters and Descriptions
Parameter  Description 

FDS_INST_NAME  

Non-Oracle system instance to be unregistered in the Oracle8i server.  

FDS_CLASS_NAME  

The class associated with the non-Oracle system instance.  

Exceptions
Exception  Description 

ORA-24274  

The instance could not be dropped. Did you pass an existing CLASS or INSTANCE name?  

See Also

DBMS_HS.CREATE_FDS_INST

DBMS_HS.DROP_INST_INIT

Purpose

To drop an initialization variable of a specific non-Oracle system instance. You can query initialization parameters that are defined for a particular instance using the HS_INST_INIT and HS_ALL_INIT view.

Interface description

PROCEDURE drop_inst_init( 
FDS_INST_NAME   IN VARCHAR2,
FDS_CLASS_NAME  IN VARCHAR2,
INIT_VALUE_NAME IN VARCHAR2)

Parameters and Descriptions
Parameter  Description 

FDS_INST_NAME  

Non-Oracle system instance for which the initialization parameter needs to be dropped.  

FDS_CLASS_NAME  

The class associated with the non-Oracle system instance.  

INIT_VALUE_NAME  

Name of the initialization parameters.  

Exceptions
Exception  Description 

ORA-24274  

The initialization parameter could not be dropped. Did you pass an existing CLASS or INSTANCE name?  

See Also

DBMS_HS.CREATE_INST_INIT




Prev

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index