Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Heterogeneous Services Concepts

What is Heterogeneous Services?

Heterogeneous Services Process Architecture

What is an Agent?

Oracle Transparent Gateways

Generic Connectivity

Heterogeneous Services Components

Transaction Service

SQL Service

Database Links to a Non-Oracle System

Architecture of the Heterogenous Services Data Dictionary

Classes and Instances

Configuration Data

Data Dictionary Views

2 Managing Heterogeneous Services

Setting Up Access to Non-Oracle Systems

Step 1: Install the Heterogeneous Services Data Dictionary

Step 2: Set Up the Environment to Access Heterogeneous Services Agents

Step 3: Create the Database Link to the Non-Oracle System

Step 4: Test the Connection

Registering Agents

Enabling Agent Self-Registration

Disabling Agent Self-Registration

Using Agent Self-Registration to Avoid Configuration Mismatches

Understanding Agent Self-Registration

Specifying HS_AUTOREGISTER

Using Heterogeneous Services Data Dictionary Views

Understanding Types of Views

Understanding Sources of Data Dictionary Information

Using General Views

Using Transaction Service Views

Using SQL Service Views

Using the Heterogeneous Services Dynamic Performance Views

Determining Which Agents Are Running on a Host

Determining the Open Heterogeneous Services Sessions

Determining the Heterogeneous Services Parameters

Using the DBMS_HS Package

Specifying Initialization Parameters

Unspecifying Initialization Parameters

3 Generic Connectivity

What Is Generic Connectivity?

Types of Agents

Generic Connectivity Architecture

SQL Execution

Datatype Mapping

Generic Connectivity Restrictions

Supported Oracle SQL Statements

Functions Supported by Generic Connectivity

Configuring Generic Connectivity Agents

Creating the Initialization File

Editing the Initialization File

Setting Initialization Parameters for an ODBC-based Data Source

Setting Initialization Parameters for an OLE DB-based Data Source

ODBC Connectivity Requirements

OLE DB (SQL) Connectivity Requirements

OLE DB (FS) Connectivity Requirements

Data Source Properties

4 Developing Applications with Heterogeneous Services

Developing Applications with Heterogeneous Services: Overview

Developing Applications Using Pass-Through SQL

Using the DBMS_HS_PASSTHROUGH package

Considering the Implications of Using Pass-Through SQL

Executing Pass-Through SQL Statements

Optimizing Data Transfers Using Bulk Fetch

Using OCI, an Oracle Precompiler, or Another Tool for Array Fetches

Controlling the Array Fetch Between Oracle Database Server and Agent

Controlling the Array Fetch Between Agent and Non-Oracle Server

Controlling the Reblocking of Array Fetches

Researching the Locking Behavior of Non-Oracle Systems

Limitations to Heterogeneous Services

A Heterogeneous Services Initialization Parameters

HS_COMMIT_POINT_STRENGTH

HS_DB_DOMAIN

HS_DB_INTERNAL_NAME

HS_DB_NAME

HS_DESCRIBE_CACHE_HWM

HS_FDS_CONNECT_INFO

HS_FDS_SHAREABLE_NAME

HS_FDS_TRACE_LEVEL

HS_FDS_TRACE_FILE_NAME

HS_LANGUAGE

HS_NLS_DATE_FORMAT

HS_NLS_DATE_LANGUAGE

HS_NLS_NCHAR

HS_OPEN_CURSORS

HS_ROWID_CACHE_SIZE

HS_RPC_FETCH_REBLOCKING

HS_RPC_FETCH_SIZE

B Heterogeneous Services Data Dictionary Views

C DBMS_HS_PASSTHROUGH for Pass-Through SQL

Summary of Subprograms

BIND_VARIABLE procedure

BIND_VARIABLE_RAW procedure

BIND_OUT_VARIABLE procedure

BIND_OUT_VARIABLE_RAW procedure

BIND_INOUT_VARIABLE procedure

BIND_INOUT_VARIABLE_RAW procedure

CLOSE_CURSOR function

EXECUTE_IMMEDIATE function

EXECUTE_NON_QUERY function

FETCH_ROW function

GET_VALUE procedure

GET_VALUE_RAW procedure

OPEN_CURSOR function

PARSE procedure

D Data Dictionary Translation for Generic Connectivity

Data Dictionary Translation Support

Accessing the Non-Oracle Data Dictionary

Supported Views and Tables

Data Dictionary Mapping

Default Column Values

Generic Connectivity Data Dictionary Descriptions

ALL_CATALOG

ALL_COL_COMMENTS

ALL_CONS_COLUMNS

ALL_CONSTRAINTS

ALL_IND_COLUMNS

ALL_INDEXES

ALL_OBJECTS

ALL_TAB_COLUMNS

ALL_TAB_COMMENTS

ALL_TABLES

ALL_USERS

ALL_VIEWS

DICTIONARY

USER_CATALOG

USER_COL_COMMENTS

USER_CONS_COLUMNS

USER_CONSTRAINTS

USER_IND_COLUMNS

USER_INDEXES

USER_OBJECTS

USER_TAB_COLUMNS

USER_TAB_COMMENTS

USER_TABLES

USER_USERS

USER_VIEWS

E Datatype Mapping

Mapping ODBC Datatypes to Oracle Datatypes

Mapping OLE DB Datatypes to Oracle Datatypes

Index