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

Part Number B14307-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

Oracle Data Provider for .NET Assembly

The Oracle.DataAccess.dll assembly provides two namespaces:

Oracle.DataAccess.Client Namespace

The Oracle.DataAccess.Client namespace contains implementations of core ADO.NET classes and enumerations for ODP.NET, as well as ODP.NET specific classes.

The following tables list ODP.NET classes, enumerations, and types that are supported by the Oracle.DataAccess.Client namespace. The tables also indicated which classes are not supported in .NET stored procedures.

Oracle.DataAccess.Client

Table 1-1 lists the client classes.

Table 1-1 Oracle.DataAccess.Client

Class Description
OnChangeEventHandler Delegate
The OnChangedEventHandler event delegate represents the signature of the method that handles the notification.

Not Supported in a .NET Stored Procedure

OracleCommand Class
An OracleCommand object represents a SQL command, a stored procedure or function, or a table name.
OracleCommandBuilder Class
An OracleCommandBuilder object provides automatic SQL generation for the OracleDataAdapter when the database is updated.
OracleConnection Class
An OracleConnection object represents a connection to Oracle Database.
OracleDataAdapter Class
An OracleDataAdapter object represents a data provider object that communicates with the DataSet.
OracleDataReader Class
An OracleDataReader object represents a forward-only, read-only, in-memory result set.
OracleDependency Class
An OracleDependency class represents a dependency between an application and an Oracle database.

Not Supported in a .NET Stored Procedure

OracleError Class
The OracleError object represents an error reported by an Oracle database.
OracleErrorCollection Class
An OracleErrorCollection object represents a collection of OracleErrors.
OracleException Class
The OracleException object represents an exception that is thrown when Oracle Data Provider for .NET encounters an error.
OracleFailoverEventArgs Class
The OracleFailoverEventArgs class provides event data for the OracleConnection.Failover event.

Not Supported in a .NET Stored Procedure

OracleFailoverEventHandler Delegate
The OracleFailoverEventHandler represents the signature of the method that handles the OracleConnection.Failover event.

Not Supported in a .NET Stored Procedure

OracleGlobalization Class
The OracleGlobalization class is used to obtain and set the Oracle globalization settings of the session, thread, and local computer (read-only).
OracleInfoMessageEventArgs Class
The OracleInfoMessageEventArgs object provides event data for the OracleConnection.InfoMessage event.
OracleInfoMessageEventHandler Delegate
The OracleInfoMessageEventHandler delegate represents the signature of the method that handles the OracleConnection.InfoMessage event.
OracleNotificationEventArgs Class
The OnChangedEventArgs class provides event data for a notification.
OracleNotificationRequest Class
An OracleNotificationRequest class represents a notification request to be subscribed in the database.

Not Supported in a .NET Stored Procedure

OracleParameter Class
An OracleParameter object represents a parameter for an OracleCommand.
OracleParameterCollection Class
An OracleParameterCollection object represents a collection of OracleParameters.
OracleRowUpdatedEventArgs Class
The OracleRowUpdatedEventArgs object provides event data for the OracleDataAdapter.RowUpdated event.
OracleRowUpdatedEventHandler Delegate
The OracleRowUpdatedEventHandler delegate represents the signature of the method that handles the OracleDataAdapter.RowUpdated event.
OracleRowUpdatingEventArgs Class
The OracleRowUpdatingEventArgs object provides event data for the OracleDataAdapter.RowUpdating event.
OracleRowUpdatingEventHandler Delegate
The OracleRowUpdatingEventHandler delegate represents the signature of the method that handles the OracleDataAdapter.RowUpdating event.
OracleTransaction Class
An OracleTransaction object represents a local transaction.

Not Supported in a .NET Stored Procedure

OracleXmlQueryProperties Class
An OracleXmlQueryProperties object represents the XML properties used by the OracleCommand class when the XmlCommandType property is Query.
OracleXmlSaveProperties Class
An OracleXmlSaveProperties object represents the XML properties used by the OracleCommand class when the XmlCommandType property is Insert, Update, or Delete.

Oracle.DataAccess.Client Enumerations

Table 1-2 lists the client enumerations.

Table 1-2 Oracle.DataAccess.Client Enumerations

Enumeration Description
FailoverEvent Enumeration
FailoverEvent enumerated values are used to specify the state of the failover.

Not Supported in a .NET Stored Procedure

FailoverReturnCode Enumeration
FailoverReturnCode enumerated values are passed back by the application to the ODP.NET provider to request a retry in case of a failover error, or to continue in case of a successful failover.

Not Supported in a .NET Stored Procedure

FailoverType Enumeration
FailoverType enumerated values are used to indicate the type of failover event that was raised.

Not Supported in a .NET Stored Procedure

OracleCollectionType Enumeration
OracleCollectionType enumerated values specify whether or not the OracleParameter object represents a collection, and if so, specifies the collection type.

Not Supported in a .NET Stored Procedure

OracleDbType Enumeration
OracleDbType enumerated values are used to explicitly specify the OracleDbType of an OracleParameter.
OracleNotificationInfo Enumeration
OracleNotificationInfo enumerated values specify the database event that causes the notification.

Not Supported in a .NET Stored Procedure

OracleNotificationSource Enumeration
OracleNotificationSource enumerated values specify the different sources that cause notification.

Not Supported in a .NET Stored Procedure

OracleNotificationType Enumeration
OracleNotificationType enumerated values specify the different types that cause the notification.

Not Supported in a .NET Stored Procedure

OracleParameterStatus Enumeration
The OracleParameterStatus enumeration type indicates whether a NULL value is fetched from a column, or truncation has occurred during the fetch, or a NULL value is to be inserted into a database column.
OracleXmlCommandType Enumeration
The OracleXmlCommandType enumeration specifies the values that are allowed for the OracleXmlCommandType property of the OracleCommand class.

Oracle.DataAccess.Types Namespace

The Oracle.DataAccess.Types namespace provides classes, structures, and exceptions for Oracle native types that can be used with Oracle Data Provider for .NET.

Oracle.DataAccess.Types Structures

Table 1-3 lists the type structures.

Table 1-3 Oracle.DataAccess.Types Structures

Structure Description
OracleBinary Structure
The OracleBinary structure represents a variable-length stream of binary data.
OracleDate Structure
The OracleDate structure represents the Oracle DATE datatype.
OracleDecimal Structure
The OracleDecimal structure represents an Oracle NUMBER in the database or any Oracle numeric value.
OracleIntervalDS Structure
The OracleIntervalDS structure represents the Oracle INTERVAL DAY TO SECOND datatype.
OracleIntervalYM Structure
The OracleIntervalYM structure represents the Oracle INTERVAL YEAR TO MONTH datatype.
OracleString Structure
The OracleString structure represents a variable-length stream of characters.
OracleTimeStamp Structure
The OracleTimeStamp structure represents the Oracle TimeStamp datatype.
OracleTimeStampLTZ Structure
The OracleTimeStampLTZ structure represents the Oracle TIMESTAMP WITH LOCAL TIME ZONE datatype.
OracleTimeStampTZ Structure
The OracleTimeStampTZ structure represents the Oracle TIMESTAMP WITH TIME ZONE datatype.

Oracle.DataAccess.Types Exceptions

Type Exceptions are thrown only by ODP.NET type structures. Table 1-4 lists the type exceptions.

Table 1-4 Oracle.DataAccess.Types Exceptions

Exception Description
OracleTypeException Class
The OracleTypeException object is the base exception class for handling exceptions that occur in the ODP.NET Types classes.
OracleNullValueException Class
The OracleNullValueException represents an exception that is thrown when trying to access an ODP.NET Types structure that is null.
OracleTruncateException Class
The OracleTruncateException class represents an exception that is thrown when truncation in an ODP.NET Types class occurs.

Oracle.DataAccess.Types Classes

Table 1-5 lists the type classes.

Table 1-5 Oracle.DataAccess.Types Classes

Class Description
OracleBFile Class
An OracleBFile is an object that has a reference to BFILE data. It provides methods for performing operations on BFILE objects.
OracleBlob Class
An OracleBlob object is an object that has a reference to BLOB data. It provides methods for performing operations on BLOB objects.
OracleClob Class
An OracleClob is an object that has a reference to CLOB data. It provides methods for performing operations on CLOB objects.
OracleRefCursor Class
An OracleRefCursor object represents an Oracle REF CURSOR.
OracleXmlStream Class
An OracleXmlStream object represents a sequential read-only stream of XML data stored in an OracleXmlType object.
OracleXmlType Class
An OracleXmlType object represents an Oracle XmlType instance.