1/12

Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

1 Introduction to the Oracle Database Gateway for SQL Server

• Overview of Oracle Database Gateways
• About Heterogeneous Services Technology
• About Oracle Database Gateway for SQL Server

2 SQL Server Gateway Features and Restriction

• Remote Insert Rowsource
• 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
  • Functions
  • SQL*Plus COPY Command with Lowercase Table Names
  • Database 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

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
• 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
• DBA_CATALOG
• DBA_COL_COMMENTS
• DBA_OBJECTS
• DBA_TAB_COLUMNS
• DBA_TAB_COMMENTS
• DBA_TABLES
• DICT_COLUMNS
• DICTIONARY
• DUAL
• TABLE_PRIVILEGES
• USER_CATALOG
• USER_COL_COMMENTS
• USER_CONS_COLUMNS
• USER_CONSTRAINTS
• USER_IND_COLUMNS
• USER_INDEXES
• USER_OBJECTS
• USER_TAB_COLUMNS
• USER_TAB_COMMENTS
• USER_TABLES
• USER_USERS
• USER_VIEWS

D Initialization Parameters

• Initialization Parameter File Syntax
• Oracle Database Gateway for SQL Server Initialization Parameters
• 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_FDS_ENCRYPT_SESSION
• HS_FDS_TRANSACTION_ISOLATION
• HS_FDS_TRUSTSTORE_FILE
• HS_FDS_TRUSTSTORE_PASSWORD
• HS_FDS_VALIDATE_SERVER_CERT
• HS_TRANSACTION_MODEL
• IFILE
• HS_FDS_TIMESTAMP_MAPPING
• HS_FDS_DATE_MAPPING
• 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
• HS_FDS_ARRAY_EXEC

Index