Skip Headers
Oracle® Data Provider for .NET Developer's Guide
10g Release 2 (10.2)

B14307-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to next page
Next
PDF · Mobi · ePub

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