Skip Headers
Oracle® Database Gateway for SQL Server User's Guide,
11g Release 1 (11.1)
Part Number B31049-03
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
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
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
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_DEFAULT_OWNER
HS_FDS_PROC_IS_FUNC
HS_FDS_RECOVERY_ACCOUNT
HS_FDS_RECOVERY_PWD
HS_FDS_RESULTSET_SUPPORT
HS_FDS_TRACE_LEVEL
HS_FDS_TRANSACTION_LOG
HS_FDS_REPORT_REAL_AS_DOUBLE
HS_FDS_FETCH_ROWS
Index