1/12

Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to Oracle Database Gateway for ODBC

• Overview of Oracle Database Gateways
• About Heterogeneous Services Technology
• About Oracle Database Gateway for ODBC
• Oracle Database Gateway for ODBC Architecture
  • Oracle and Non-Oracle Systems on Separate Machines
  • Oracle and Non-Oracle Systems on the Same Machine
• ODBC Connectivity Requirements

2 Oracle Database Gateway for ODBC Features and Restrictions

• Using the Pass-Through Feature
• Using AUTO COMMIT
• Known Restrictions
  • COMMIT or ROLLBACK in PL/SQL Cursor Loops Closes Open Cursors
  • SQL Syntax Restrictions
    • WHERE CURRENT OF Clause
    • CONNECT BY Clause
    • ROWID
    • EXPLAIN PLAN Statement
  • CALLBACK Links Support
• Known Problems
  • Encrypted Format Login
  • Date Arithmetic

A Data Type Conversion

B Supported SQL Syntax and Functions

• Supported SQL Statements
  • DELETE
  • INSERT
  • SELECT
  • UPDATE
• Oracle Functions

C Data Dictionary

• Accessing the Non-Oracle Data Dictionary
• Views and Tables Supported by Oracle Database Gateway for ODBC
  • Data Dictionary Mapping
  • 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
  • DICT_COLUMNS
  • USER_CATALOG
  • USER_COL_COMMENTS
  • USER_CONS_COLUMNS
  • USER_CONSTRAINTS
  • USER_IND_COLUMNS
  • USER_INDEXES
  • USER_OBJECTS
  • USER_TABCOLUMNS
  • USER_TAB_COMMENTS
  • USER_TABLES
  • USER_USERS
  • USER_VIEWS

D Initialization Parameters

• Initialization Parameter File Syntax
• Oracle Database Gateway for ODBC Initialization Parameters
  • HS_DB_DOMAIN
  • HS_DB_INTERNAL_NAME
  • HS_DB_NAME
  • HS_DESCRIBE_CACHE_HWM
  • HS_LANGUAGE
    • Character Sets
    • Language
    • Territory
  • HS_LONG_PIECE_TRANSFER_SIZE
  • HS_OPEN_CURSORS
  • HS_RPC_FETCH_REBLOCKING
  • HS_RPC_FETCH_SIZE
  • HS_TIME_ZONE
  • HS_TRANSACTION_MODEL
  • IFILE
  • HS_FDS_TIMESTAMP_MAPPING
  • HS_FDS_DATE_MAPPING
  • HS_FDS_CONNECT_INFO
  • HS_FDS_DEFAULT_OWNER
  • HS_FDS_TRACE_LEVEL
  • HS_FDS_SHAREABLE_NAME
  • HS_FDS_FETCH_ROWS
  • HS_FDS_REMOTE_DB_CHARSET
  • HS_FDS_SQLLEN_INTERPRETATION
  • HS_FDS_REPORT_REAL_AS_DOUBLE

Index