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 11.1
• New Features in Oracle Data Provider for .NET Release 10.2.0.3
• New Features in Oracle Data Provider for .NET Release 10.2.0.2
• 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
• Oracle Data Provider for .NET Versioning Scheme
• Installing Oracle Data Provider for .NET
• File Locations After Installation
  • Windows Registry
  • Search Order for Unmanaged DLLs
  • ODP.NET and Dependent Unmanaged DLL Mismatch

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 Pool Management
  • Connecting in Real Application Clusters (RAC) Database
    • Connection Optimizations for Oracle RAC
    • Pool Size Attributes in an Oracle RAC Database
  • Operating System Authentication
  • Privileged Connections
  • Password Expiration
  • Proxy Authentication
  • Dynamic Distributed Transaction Enlistment
  • Client Identifier
  • Transparent Application Failover (TAF) Callback Support
    • TAF Notification
    • When Failover Occurs
    • Registering an Event Handler for Failover
• ADO.NET 2.0 Features
  • About ADO.NET 2.0
  • Backward Compatibility for ADO.NET
  • Base Classes and Provider Factory Classes
  • Connection String Builder
  • Data Source Enumerator
  • Support for Schema Discovery
    • User Customization of Metadata
  • System.Transactions Support
    • Implicit Distributed Transaction Enlistment Using TransactionScope
    • Explicit Distributed Transaction Enlistment Using CommittableTransaction
    • Local Transaction for System.Transactions Support
  • Batch Processing Support
  • ADO.NET 2.0 Only Classes and Class Members
• OracleCommand Object
  • Transactions
  • Parameter Binding
    • Data Types 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 Data Type
  • 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 Data Types
  • 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
  • XQuery Support
  • 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
    • Saving Changes to a Table Using an XML Document
    • 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 Data Types 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
• ODP.NET Configuration

4 Oracle Data Provider for .NETServer-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 ADO.NET 2.0 Classes

• OracleClientFactory Class
  • OracleClientFactory Members
  • OracleClientFactory Public Properties
  • OracleClientFactory Public Methods
• OracleConnectionStringBuilder Class
  • OracleConnectionStringBuilder Members
  • OracleConnectionStringBuilder Constructors
  • OracleConnectionStringBuilder Public Properties
  • OracleConnectionStringBuilder Public Methods
• OracleDataSourceEnumerator Class
  • OracleDataSourceEnumerator Members
  • OracleDataSourceEnumerator Public Methods

8 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

9 Oracle Data Provider for .NET Globalization Classes

• OracleGlobalization Class
  • OracleGlobalization Members
  • OracleGlobalization Static Methods
  • OracleGlobalization Properties
  • OracleGlobalization Public Methods

10 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

11 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

12 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

13 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

A Oracle Schema Collections

• Common Schema Collections
  • MetaDataCollections
  • DataSourceInformation
  • DataTypes
  • Restrictions
  • ReservedWords
• ODP.NET-Specific Schema Collection
  • Tables
  • Columns
  • Views
  • XMLSchema
  • Users
  • Synonyms
  • Sequences
  • Functions
  • Procedures
  • ProcedureParameters
  • Arguments
  • Packages
  • PackageBodies
  • JavaClasses
  • Indexes
  • IndexColumns
  • PrimaryKeys
  • ForeignKeys
  • ForeignKeyColumns
  • UniqueKeys

Glossary

Index