|
Oracle® Data Provider for .NET Developer's Guide
10g Release 1 (10.1.0.3) Part No. B14164-01 |
|
|
|
|
Oracle® Data Provider for .NET Developer's Guide
10g Release 1 (10.1.0.3) Part No. B14164-01 |
|
|
|
|
Oracle.DataAccess.dll assembly provides two namespaces:
The Oracle.DataAccess.Client namespace contains ODP.NET classes and enumerations.
The Oracle.DataAccess.Types namespace contains the Oracle Data Provider for .NET Types (ODP.NET Types).
The Oracle.DataAccess.Client contains ODP.NET classes and enumerations.
Table 1-1 lists the client classes.
Table 1-1 Oracle.DataAccess.Client Classes
| Class | Description |
|---|---|
| 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 updates are made to the database
|
| OracleConnection Class
|
An OracleConnection object represents a connection to an 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
|
| 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 object provides event data for the OracleConnection.Failover event
|
| OracleFailoverEventHandler Delegate | The OracleFailoverEventHandler delegate represents the signature of the method that handles the OracleConnection.Failover event
|
| OracleGlobalization Class
|
The OracleGlobalization class is used to obtain and set the Oracle globalization settings of the session, thread, and local computer (read-only)
|
| OracleInfoMessageEventHandler Delegate
|
The OracleInfoMessageEventHandler delegate represents the signature of the method that handles the OracleConnection.InfoMessage event
|
| OracleInfoMessageEventArgs Class
|
The OracleInfoMessageEventArgs object provides event data for the OracleConnection.InfoMessage event
|
| 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
|
| 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
|
Table 1-2 lists the client enumerations.
Table 1-2 Oracle.DataAccess.Client Enumerations
| Enumeration | Description |
|---|---|
| FailoverEvent Enumeration
|
FailoverEvent enumerated values are used to explicitly specify the state of the failover
|
| 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
|
| FailoverType Enumeration
|
FailoverType enumerated values are used to indicate the type of failover event that was raised
|
| OracleCollectionType Enumeration
|
OracleCollectionType enumerated values specify whether the OracleParameter object represents a collection, and if so, specifies the collection type
|
| OracleDbType Enumeration
|
OracleDbType enumerated values are used to explicitly specify the OracleDbType of an OracleParameter
|
| OracleParameterStatus Enumeration
|
The OracleParameterStatus enumeration type indicates whether a NULL value is fetched from a column, whether truncation has occurred during the fetch, or whether 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
|
The Oracle.DataAccess.Types namespace provides classes, structures, and exceptions for Oracle native types that can be used with Oracle Data Provider for .NET.
Table 1-3 lists the types 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 data type
|
| OracleTimeStampTZ Structure
|
The OracleTimeStampTZ structure represents the Oracle TIMESTAMP WITH TIME ZONE data type
|
Types exceptions are thrown only by ODP.NET types structures. Table 1-4 lists the types 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 Type classes
|
| OracleNullValueException Class
|
The OracleNullValueException represents an exception that is thrown when trying to access an ODP.NET Type structure that is null
|
| OracleTruncateException Class
|
The OracleTruncateException class represents an exception that is thrown when truncation in an ODP.NET Type class occurs
|
Table 1-5 lists the types 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 BFiles
|
| OracleBlob Class
|
An OracleBlob object is an object that has a reference to BLOB data. It provides methods for performing operations on BLOBs
|
| OracleClob Class
|
An OracleClob is an object that has a reference to CLOB data. It provides methods for performing operations on CLOBs
|
| 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
|
