Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

• 1.1 Overview
• 1.2 Heterogeneous Services Technology
• 1.3 Oracle Database Gateway for ODBC
• 1.4 Oracle Database Gateway for ODBC Architecture
  • 1.4.1 Oracle and Non-Oracle Systems on Separate Machines
  • 1.4.2 Oracle and Non-Oracle Systems on the Same Machine
• 1.5 ODBC Connectivity Requirements

2 Oracle Database Gateway for ODBC Features and Restrictions

• 2.1 Using the Pass-Through Feature
• 2.2 AUTO COMMIT
• 2.3 Known Restrictions
  • 2.3.1 COMMIT or ROLLBACK in PL/SQL Cursor Loops Closes Open Cursors
  • 2.3.2 SQL Syntax
    • 2.3.2.1 WHERE CURRENT OF Clause
    • 2.3.2.2 CONNECT BY Clause
    • 2.3.2.3 ROWID
    • 2.3.2.4 EXPLAIN PLAN Statement
  • 2.3.3 Does not support CALLBACK links
• 2.4 Known Problems
  • 2.4.1 Encrypted Format Login
  • 2.4.2 Date Arithmetic

A Data Type Conversion

• A.1 Mapping ODBC Data Types to Oracle Data Types

B Supported SQL Syntax and Functions

• B.1 Supported SQL Statements
  • B.1.1 DELETE
  • B.1.2 INSERT
  • B.1.3 SELECT
  • B.1.4 UPDATE
• B.2 Oracle Functions

C Data Dictionary

• C.1 Accessing the Non-Oracle Data Dictionary
• C.2 Views and Tables Supported by Oracle Database Gateway for ODBC
  • C.2.1 Data Dictionary Mapping
  • C.2.2 Oracle Database Gateway for ODBC Data Dictionary Descriptions

D Initialization Parameters

• D.1 Initialization Parameter File Syntax
• D.2 Oracle Database Gateway for ODBC Initialization Parameters
• D.3 Initialization Parameter Description
  • D.3.1 HS_DB_DOMAIN
  • D.3.2 HS_DB_INTERNAL_NAME
  • D.3.3 HS_DB_NAME
  • D.3.4 HS_DESCRIBE_CACHE_HWM
  • D.3.5 HS_LANGUAGE
    • D.3.5.1 Character Sets
    • D.3.5.2 Language
    • D.3.5.3 Territory
  • D.3.6 HS_LONG_PIECE_TRANSFER_SIZE
  • D.3.7 HS_OPEN_CURSORS
  • D.3.8 HS_RPC_FETCH_REBLOCKING
  • D.3.9 HS_RPC_FETCH_SIZE
  • D.3.10 HS_TIME_ZONE
  • D.3.11 HS_TRANSACTION_MODEL
  • D.3.12 IFILE
  • D.3.13 HS_FDS_CONNECT_INFO
  • D.3.14 HS_FDS_DEFAULT_OWNER
  • D.3.15 HS_FDS_TRACE_LEVEL
  • D.3.16 HS_FDS_SHAREABLE_NAME
  • D.3.17 HS_FDS_FETCH_ROWS
  • D.3.18 HS_FDS_REMOTE_DB_CHARSET
  • D.3.19 HS_FDS_SQLLEN_INTERPRETATION
  • D.3.20 HS_FDS_REPORT_REAL_AS_DOUBLE

Index