1/12
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
Scripting on this page enhances content navigation, but does not change the content in any way.