Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

1 Introduction

• Overview
• Heterogeneous Services Technology
• Oracle Database Gateways

2 SQL Server Gateway Features and Restriction

• Using the Pass-Through Feature
• Executing Stored Procedures and Functions
• CHAR Semantics
• Multi-byte Character Sets Ratio Suppression
• IPv6 Support
• Gateway Session IDLE Timeout
• Remote User-defined Function Support
  • Return Values and Stored Procedures
  • Result Sets and Stored Procedures
    • OCI Program Fetching from Result Sets in Sequential Mode
    • PL/SQL Program Fetching from Result Sets in Sequential Mode
• Database Compatibility Issues for SQL Server
  • Implicit Transactions (Chained Mode)
  • Column Definitions
  • Naming Rules
    • Rules for Naming Objects
    • Case Sensitivity
  • Data Types
    • Binary Literal Notation
    • Bind Variables With LONG Columns
    • Data Type Conversion
  • Queries
    • Row Selection
    • Empty Strings
    • Empty Bind Variables
  • Locking
• Known Restrictions
  • Multiple Open Statements
  • Transactional Integrity
  • Transaction Capability
  • COMMIT or ROLLBACK in PL/SQL Cursor Loops Closes Open Cursors
  • Stored Procedures
  • Pass-Through Feature
  • DDL Statements
  • SQL Syntax
    • WHERE CURRENT OF Clause
    • CONNECT BY Clause
    • Functions in Subqueries
    • Parameters in Subqueries
    • Data Dictionary Table and Views in UPDATE Statement
    • ROWID
    • TO_DATE
    • EXPLAIN PLAN Statement
    • Callback Support
  • Functions
  • SQL*Plus COPY Command with Lowercase Table Names
  • Database Links
  • CALLBACK links
• Known Problems
  • Encrypted Format Login
  • Date Arithmetic
  • SQL Server IMAGE, TEXT and NTEXT Data Types
  • String Functions
  • Schema Names and PL/SQL
  • Data Dictionary Views and PL/SQL
  • Stored Procedures

3 Case Studies

• Case Descriptions
• Installation Media Contents
• Demonstration Files
• Demonstration Requirements
• Creating Demonstration Tables
  • Demonstration Table Definitions
  • Demonstration Table Contents
• Case 1: Simple Queries
• Case 2: A More Complex Query
• Case 3: Joining SQL Server Tables
• Case 4: Write Capabilities
  • DELETE Statement
  • UPDATE Statement
  • INSERT Statement
• Case 5: Data Dictionary Query
• Case 6: The Pass-Through Feature
  • UPDATE Statement
  • SELECT Statement
• Case 7: Executing Stored Procedures

A Data Type Conversion

• Data Type Conversion

B Supported SQL Syntax and Functions

• Supported SQL Statements
  • DELETE
  • INSERT
  • SELECT
  • UPDATE
• Oracle Functions
  • Functions Not Supported by SQL Server
  • Functions Supported by SQL Server
    • Arithmetic Operators
    • Comparison Operators
    • Pattern Matching
    • Group Functions
    • String Functions
    • Other Functions
  • Functions Supported by the Gateway

C Data Dictionary

• Data Dictionary Support
  • SQL Server System Tables
  • Accessing the Gateway Data Dictionary
  • Direct Queries to SQL Server Tables
  • Supported Views and Tables
• Data Dictionary Mapping
  • Default Column Values
• Gateway Data Dictionary Descriptions

D Initialization Parameters

• Initialization Parameter File Syntax
• Oracle Database Gateway for SQL Server Initialization Parameters
• Initialization Parameter Description
  • HS_CALL_NAME
  • 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_CONNECT_INFO
  • HS_FDS_PROC_IS_FUNC
  • HS_FDS_RECOVERY_ACCOUNT
  • HS_FDS_RECOVERY_PWD
  • HS_FDS_REPORT_REAL_AS_DOUBLE
  • HS_FDS_RESULTSET_SUPPORT
  • HS_FDS_TRACE_LEVEL
  • HS_FDS_TRANSACTION_LOG
  • HS_FDS_FETCH_ROWS
  • HS_IDLE_TIMEOUT
  • HS_NLS_LENGTH_SEMANTICS
  • HS_KEEP_REMOTE_COLUMN_SIZE
  • HS_FDS_REMOTE_DB_CHARSET
  • HS_FDS_SUPPORT_STATISTICS
  • HS_FDS_RSET_RETURN_ROWCOUNT
  • HS_FDS_SQLLEN_INTERPRETATION

Index