Oracle Data Provider for .NET Developer's Guide -- Contents

Overview of Oracle Data Provider for .NET (ODP.NET)

ODP.NET Assembly

Oracle.DataAccess.Client Classes and Enumerations

Oracle.DataAccess.Types Classes and Structures

Using ODP.NET in a Simple Application

System Requirements

Installing Oracle Data Provider for .NET

File Locations

Connecting to the Oracle Database Server

Connection String Attributes

Connection Pooling

Operating System Authentication

Privileged Connections

Password Expiration

Proxy Authentication

Transparent Application Failover (TAF) Callback Support

ODP.NET Types Overview

Obtaining Data From an OracleDataReader

Typed OracleDataReader Accessors

.NET Type Accessors

ODP.NET Type Accessors

Obtaining LONG and LONG RAW Data

Obtaining LOB Data

Controlling the Number of Rows Fetched in One Server Round-Trip

Use of FetchSize

Fine-Tuning FetchSize

Using the RowSize Property

Setting FetchSize Value at Design Time

Setting FetchSize Value at Runtime

OracleCommand Object

Transaction

Parameter Binding

OracleDbType Enumeration Type

Inference of DbType, OracleDbType, and .NET Types

PL/SQL Associative Array

Array Binding

PL/SQL REF CURSOR and OracleRefCursor

Obtaining an OracleRefCursor

Obtaining a REF CURSOR

Populating an OracleDataReader from a REF CURSOR

Populating the DataSet From a REF CURSOR

Populating an OracleRefCursor From a REF CURSOR

Updating a DataSet Obtained From a REF CURSOR

Behavior of ExecuteScalar Method for REF CURSOR

LOB Support

Updating LOBs Using a DataSet

Updating LOBs Using OracleCommand and OracleParameter

Updating LOBs Using ODP.NET LOB Objects

Temporary LOBs

Globalization Support

Globalization Settings

Client Globalization Settings

Session Globalization Settings

Thread-Based Globalization Settings

Globalization-Sensitive Operations

Operations Dependent on Client Computer's Globalization Settings

Operations Dependent on Thread Globalization Settings

Operations Sensitive to Session Globalization Parameters

Guaranteeing Uniqueness in Updating DataSet to Database

What Constitutes Uniqueness in DataRows?

Configuring PrimaryKey and Constraints Properties

Updating Without PrimaryKey and Constraints Configuration

OracleDataAdapter Safe Type Mapping

Potential Data Loss

SafeMapping Property

Using Safe Type Mapping

OracleDataAdapter Requery Property

Debug Tracing

Registry Settings for Tracing Calls

TraceFileName

TraceLevel

TraceOption

ODP.NET XML Support

Supported XML Features

OracleXmlType and Connection Dependency

Updating XMLType Data in the Database Server

Updating with DataSet, OracleDataAdapter, and OracleCommandBuilder

Updating with OracleCommand and OracleParameter

Updating XML Data in OracleXmlType

Special Characters in XML

Retrieving Query Result Set as XML

Handling Date and Time Format

Special Characters in Column Data

Special Characters In Table or View Name

Case-Sensitivity in Column Name to XML Element Name Mapping

Column Name to XML Element Name Mapping

Object-Relational Data

NULL values

Data Manipulation Using XML

Handling of Date and Time Format

Saving Changes Using XML

Special Characters in Column Data

Special Characters in Table or View Name

Case-Sensitivity in XML Element Name to Column Name Mapping

XML Element Name to Column Name Mapping

Object-Relational Data

Multiple Tables

Commits

Overview of Oracle Data Provider Classes

Oracle Data Provider Classes

Oracle Data Provider Enumerations

FailoverEvent Enumeration

FailoverReturnCode Enumeration

FailoverType Enumeration

OracleCollectionType Enumeration

OracleDbType Enumeration

OracleParameterStatus Enumeration

OracleXmlCommandType Enumeration

Overview of ODP.NET Types

ODP.NET Type Structures

OracleBinary Structure

OracleDate Structure

OracleDecimal Structure

OracleIntervalDS Structure

OracleIntervalYM Structure

OracleString Structure

OracleTimeStamp Structure

OracleTimeStampLTZ Structure

OracleTimeStampTZ Structure

ODP.NET Type Exceptions

OracleTypeException Class

OracleNullValueException Class

OracleTruncateException Class

ODP.NET Type Objects

OracleBFile Class

OracleBlob Class

OracleClob Class

OracleRefCursor Class

OracleXmlStream Class

OracleXmlType Class

Contents

Title and Copyright Information

Send Us Your Comments

Preface

What's New in Oracle Data Provider for .NET?

Volume 1

1 Introducing Oracle Data Provider for .NET

2 Installing and Configuring

3 Features of Oracle Data Provider for .NET

4 Oracle.DataAccess.Client Namespace

Volume 2

5 Oracle.DataAccess.Types Namespace (ODP.NET Types)

Glossary

Index