Table of 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
      • Language
        • Character Sets
      • 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