Contents

Title and Copyright Information

Preface

Audience

Documentation Accessibility

Related Documents

Conventions

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

New Features in Oracle Data Provider for .NET Release 10.2

New Features in Oracle Data Provider for .NET Release 10.1.0.3

New Features in Oracle Data Provider for .NET Release 10.1

New Features in Oracle Data Provider for .NET Release 9.2.0.4

1 Introducing Oracle Data Provider for .NET

.NET Data Access in Oracle: Products and Documentation

Oracle Data Provider for .NET (ODP.NET)

Oracle Developer Tools for Visual Studio .NET

Oracle Database Extensions for .NET

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

Oracle Data Provider for .NET Assembly

Oracle.DataAccess.Client Namespace

Oracle.DataAccess.Client

Oracle.DataAccess.Client Enumerations

Oracle.DataAccess.Types Namespace

Oracle.DataAccess.Types Structures

Oracle.DataAccess.Types Exceptions

Oracle.DataAccess.Types Classes

Using ODP.NET Client Provider in a Simple Application

2 Installing and Configuring Oracle Data Provider for .NET

System Requirements

Installing Oracle Data Provider for .NET

File Locations After Installation

3 Features of Oracle Data Provider for .NET

Connecting to Oracle Database

Connection String Attributes

Specifying the Data Source Attribute

Using the TNS Alias

Using the Connect Descriptor

Using Easy Connect Naming Method

Connection Pooling

Using Connection Pooling

Connection Pooling for a Real Application Clusters (RAC) Database

Connection Pool Optimizations for RAC

Pool Size Attributes in a RAC Database

Operating System Authentication

Privileged Connections

Password Expiration

Proxy Authentication

Client Identifier

Transparent Application Failover (TAF) Callback Support

TAF Notification

When Failover Occurs

Registering an Event Handler for Failover

OracleCommand Object

Transactions

Parameter Binding

Datatypes BINARY_FLOAT and BINARY_DOUBLE

OracleDbType Enumeration Type

Inference of DbType, OracleDbType, and .NET Types

PL/SQL Associative Array Binding

Array Binding

Statement Caching

Statement Caching Connection String Attributes

Enabling Statement Caching through the Registry

Statement Caching Methods and Properties

Connections and Statement Caching

Pooling and Statement Caching

ODP.NET Types Overview

Obtaining Data from an OracleDataReader Object

Typed OracleDataReader Accessors

.NET Type Accessors

ODP.NET Type Accessors

Obtaining LONG and LONG RAW Data

Setting InitialLONGFetchSize to Zero or a Value Greater than Zero

Setting InitialLONGFetchSize to -1

Obtaining LOB Data

Setting InitialLOBFetchSize to Zero

Setting InitialLOBFetchSize to a Value Greater than Zero

Setting InitialLOBFetchSize to -1

Performance Considerations Related to the InitialLOBFetchSize property

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

Use of FetchSize

Fine-Tuning FetchSize

Using the RowSize Property

PL/SQL REF CURSOR and OracleRefCursor

Obtaining an OracleRefCursor Object

Obtaining a REF CURSOR Datatype

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

Passing a REF CURSOR to a Stored Procedure

LOB Support

Large Character and Large Binary Datatypes

Oracle Data Provider for .NET LOB Objects

Updating LOBs Using a DataSet

Updating LOBs Using OracleCommand and OracleParameter

Updating LOBs Using ODP.NET LOB Objects

Temporary LOBs

ODP.NET XML Support

Supported XML Features

OracleXmlType and Connection Dependency

Updating XMLType Data in the Database

Updating with DataSet, OracleDataAdapter, and OracleCommandBuilder

Updating with OracleCommand and OracleParameter

Updating XML Data in OracleXmlType

Characters with Special Meaning in XML

Retrieving Query Result Set as XML

Handling Date and Time Format

Characters with Special Meaning in Column Data

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 Date and Time Format

Saving Changes Using XML

Characters with Special Meaning in Column Data

Characters with Special Meaning 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

Commit Transactions

Database Change Notification Support

Database Change Notification Classes

Supported Operations

Requirements of Notification Registration

Using Database Change Notification

Application Steps

Flow of Notification Process

Best Practice Guidelines and Performance Considerations

OracleDataAdapter Safe Type Mapping

Comparison Between Oracle Datatypes and .NET Types

SafeMapping Property

Using Safe Type Mapping

OracleDataAdapter Requery Property

Guaranteeing Uniqueness in Updating DataSet to Database

What Constitutes Uniqueness in DataRow Objects?

Configuring PrimaryKey and Constraints Properties

Updating Without PrimaryKey and Constraints Configuration

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

Debug Tracing

Registry Settings for Tracing Calls

TraceFileName

TraceLevel

TraceOption

4 Oracle Data Provider for .NET Server-Side Features

Introducing .NET Stored Procedure Execution Using ODP.NET

Limitations and Restrictions on ODP.NET Within .NET Stored Procedure

Implicit Database Connection

Transaction Support

Unsupported SQL Commands

Porting Client Application to .NET Stored Procedure

5 Oracle Data Provider for .NET Classes

OracleCommand Class

OracleCommand Members

OracleCommand Constructors

OracleCommand Static Methods

OracleCommand Properties

OracleCommand Public Methods

OracleCommandBuilder Class

OracleCommandBuilder Members

OracleCommandBuilder Constructors

OracleCommandBuilder Static Methods

OracleCommandBuilder Properties

OracleCommandBuilder Public Methods

OracleCommandBuilder Events

OracleConnection Class

OracleConnection Members

OracleConnection Constructors

OracleConnection Static Properties

OracleConnection Static Methods

OracleConnection Properties

OracleConnection Public Methods

OracleConnection Events

OracleDataAdapter Class

OracleDataAdapter Members

OracleDataAdapter Constructors

OracleDataAdapter Static Methods

OracleDataAdapter Properties

OracleDataAdapter Public Methods

OracleDataAdapter Events

OracleDataReader Class

OracleDataReader Members

OracleDataReader Static Methods

OracleDataReader Properties

OracleDataReader Public Methods

OracleError Class

OracleError Members

OracleError Static Methods

OracleError Properties

OracleError Methods

OracleErrorCollection Class

OracleErrorCollection Members

OracleErrorCollection Static Methods

OracleErrorCollection Properties

OracleErrorCollection Public Methods

OracleException Class

OracleException Members

OracleException Static Methods

OracleException Properties

OracleException Methods

OracleInfoMessageEventArgs Class

OracleInfoMessageEventArgs Members

OracleInfoMessageEventArgs Static Methods

OracleInfoMessageEventArgs Properties

OracleInfoMessageEventArgs Public Methods

OracleInfoMessageEventHandler Delegate

OracleParameter Class

OracleParameter Members

OracleParameter Constructors

OracleParameter Static Methods

OracleParameter Properties

OracleParameter Public Methods

OracleParameterCollection Class

OracleParameterCollection Members

OracleParameterCollection Static Methods

OracleParameterCollection Properties

OracleParameterCollection Public Methods

OracleRowUpdatedEventHandler Delegate

OracleRowUpdatedEventArgs Class

OracleRowUpdatedEventArgs Members

OracleRowUpdatedEventArgs Constructor

OracleRowUpdatedEventArgs Static Methods

OracleRowUpdatedEventArgs Properties

OracleRowUpdatedEventArgs Public Methods

OracleRowUpdatingEventArgs Class

OracleRowUpdatingEventArgs Members

OracleRowUpdatingEventArgs Constructor

OracleRowUpdatingEventArgs Static Methods

OracleRowUpdatingEventArgs Properties

OracleRowUpdatingEventArgs Public Methods

OracleRowUpdatingEventHandler Delegate

OracleTransaction Class

OracleTransaction Members

OracleTransaction Static Methods

OracleTransaction Properties

OracleTransaction Public Methods

OracleCollectionType Enumeration

OracleDbType Enumeration

OracleParameterStatus Enumeration

6 Oracle Data Provider for .NET XML-Related Classes

OracleXmlCommandType Enumeration

OracleXmlQueryProperties Class

OracleXmlQueryProperties Members

OracleXmlQueryProperties Constructor

OracleXmlQueryProperties Properties

OracleXmlQueryProperties Public Methods

OracleXmlSaveProperties Class

OracleXmlSaveProperties Members

OracleXmlSaveProperties Constructor

OracleXmlSaveProperties Properties

OracleXmlSaveProperties Public Methods

OracleXmlStream Class

OracleXmlStream Members

OracleXmlStream Constructor

OracleXmlStream Static Methods

OracleXmlStream Instance Properties

OracleXmlStream Instance Methods

OracleXmlType Class

OracleXmlType Members

OracleXmlType Constructors

OracleXmlType Static Methods

OracleXmlType Instance Properties

OracleXmlType Instance Methods

7 Database Change Notification

OracleDependency Class

OracleDependency Members

OracleDependency Constructors

OracleDependency Static Fields

OracleDependency Static Methods

OracleDependency Properties

OracleDependency Methods

OracleDependency Events

OracleNotificationRequest Class

OracleNotificationRequest Members

OracleNotificationRequest Static Methods

OracleNotificationRequest Properties

OracleNotificationRequest Methods

OracleNotificationEventArgs Class

OracleNotificationEventArgs Members

OracleNotificationEventArgs Static Fields

OracleNotificationEventArgs Static Methods

OracleNotificationEventArgs Properties

OracleNotificationEventArgs Methods

OnChangeEventHandler Delegate

OracleNotificationType Enumeration

OracleNotificationSource Enumeration

OracleNotificationInfo Enumeration

8 Oracle Data Provider for .NET Globalization Classes

OracleGlobalization Class

OracleGlobalization Members

OracleGlobalization Static Methods

OracleGlobalization Properties

OracleGlobalization Public Methods

9 Oracle Data Provider for .NET Failover Classes

OracleFailoverEventArgs Class

OracleFailoverEventArgs Members

OracleFailoverEventArgs Static Methods

OracleFailoverEventArgs Properties

OracleFailoverEventArgs Public Methods

OracleFailoverEventHandler Delegate

FailoverEvent Enumeration

FailoverReturnCode Enumeration

FailoverType Enumeration

10 Oracle Data Provider for .NET Types Classes

OracleBFile Class

OracleBFile Members

OracleBFile Constructors

OracleBFile Static Fields

OracleBFile Static Methods

OracleBFile Instance Properties

OracleBFile Instance Methods

OracleBlob Class

OracleBlob Members

OracleBlob Constructors

OracleBlob Static Fields

OracleBlob Static Methods

OracleBlob Instance Properties

OracleBlob Instance Methods

OracleClob Class

OracleClob Members

OracleClob Constructors

OracleClob Static Fields

OracleClob Static Methods

OracleClob Instance Properties

OracleClob Instance Methods

OracleRefCursor Class

OracleRefCursor Members

OracleRefCursor Static Methods

OracleRefCursor Properties

OracleRefCursor Instance Methods

11 Oracle Data Provider for .NET Types Structures

OracleBinary Structure

OracleBinary Members

OracleBinary Constructor

OracleBinary Static Fields

OracleBinary Static Methods

OracleBinary Static Operators

OracleBinary Static Type Conversion Operators

OracleBinary Properties

OracleBinary Instance Methods

OracleDate Structure

OracleDate Members

OracleDate Constructors

OracleDate Static Fields

OracleDate Static Methods

OracleDate Static Operators

OracleDate Static Type Conversions

OracleDate Properties

OracleDate Methods

OracleDecimal Structure

OracleDecimal Members

OracleDecimal Constructors

OracleDecimal Static Fields

OracleDecimal Static (Comparison) Methods

OracleDecimal Static (Manipulation) Methods

OracleDecimal Static (Logarithmic) Methods

OracleDecimal Static (Trigonometric) Methods

OracleDecimal Static (Comparison) Operators

OracleDecimal Static Operators (Conversion from .NET Type to OracleDecimal)

OracleDecimal Static Operators (Conversion from OracleDecimal to .NET)

OracleDecimal Properties

OracleDecimal Instance Methods

OracleIntervalDS Structure

OracleIntervalDS Members

OracleIntervalDS Constructors

OracleIntervalDS Static Fields

OracleIntervalDS Static Methods

OracleIntervalDS Static Operators

OracleIntervalDS Type Conversions

OracleIntervalDS Properties

OracleIntervalDS Methods

OracleIntervalYM Structure

OracleIntervalYM Members

OracleIntervalYM Constructors

OracleIntervalYM Static Fields

OracleIntervalYM Static Methods

OracleIntervalYM Static Operators

OracleIntervalYM Type Conversions

OracleIntervalYM Properties

OracleIntervalYM Methods

OracleString Structure

OracleString Members

OracleString Constructors

OracleString Static Fields

OracleString Static Methods

OracleString Static Operators

OracleString Type Conversions

OracleString Properties

OracleString Methods

OracleTimeStamp Structure

OracleTimeStamp Members

OracleTimeStamp Constructors

OracleTimeStamp Static Fields

OracleTimeStamp Static Methods

OracleTimeStamp Static Operators

OracleTimeStamp Static Type Conversions

OracleTimeStamp Properties

OracleTimeStamp Methods

OracleTimeStampLTZ Structure

OracleTimeStampLTZ Members

OracleTimeStampLTZ Constructors

OracleTimeStampLTZ Static Fields

OracleTimeStampLTZ Static Methods

OracleTimeStampLTZ Static Operators

OracleTimeStampLTZ Static Type Conversions

OracleTimeStampLTZ Properties

OracleTimeStampLTZ Methods

OracleTimeStampTZ Structure

OracleTimeStampTZ Members

OracleTimeStampTZ Constructors

OracleTimeStampTZ Static Fields

OracleTimeStampTZ Static Methods

OracleTimeStampTZ Static Operators

OracleTimeStampTZ Static Type Conversions

OracleTimeStampTZ Properties

OracleTimeStampTZ Methods

12 Oracle Data Provider for .NET Types Exceptions

OracleTypeException Class

OracleTypeException Members

OracleTypeException Constructors

OracleTypeException Static Methods

OracleTypeException Properties

OracleTypeException Methods

OracleNullValueException Class

OracleNullValueException Members

OracleNullValueException Constructors

OracleNullValueException Static Methods

OracleNullValueException Properties

OracleNullValueException Methods

OracleTruncateException Class

OracleTruncateException Members

OracleTruncateException Constructors

OracleTruncateException Static Methods

OracleTruncateException Properties

OracleTruncateException Methods

Glossary

Index