System.Data.OracleClient Namespace
The System.Data.OracleClient namespace is the .NET Framework Data Provider for Oracle.
The .NET Framework Data Provider for Oracle describes a collection of classes used to access an Oracle data source in the managed space. Using the OracleDataAdapter class, you can fill a memory-resident DataSet, which you can use to query and update the data source.
For additional information about how to use this namespace, see the OracleDataReader, the OracleCommand, and the OracleConnection classes. For conceptual information about using this namespace when programming with the .NET Framework, see "Accessing Data with ADO.NET".
The .NET Framework Data Provider for Oracle supports a number of Oracle data types, including the BFILE, LOB, and REF CURSOR data types. For information about using Oracle data types in parameters, OracleType.
When using the data provider to work with Oracle REF CURSOR data types, you should consider the following behaviors. Note that some behaviors differ from those of the Microsoft OLE DB Provider for Oracle (MSDAORA).
- For performance reasons, the data provider does not automatically bind REF CURSOR data types as MSDAORA does unless you explicitly specify them.
- The data provider does not support any ODBC escape sequences, including the {resultset...} escape used to specify REF CURSOR parameters.
- To execute a stored procedure that returns REF CURSOR data types, you must define the parameters in the OracleParameterCollection with an OracleType of Cursor and a Direction of Output. The data provider supports binding REF CURSOR data types as output parameters only. The provider does not support REF CURSOR data types as input parameters.
- In this release, obtaining an OracleDataReader from the parameter value is not supported. The values are of type DBNull. after command execution.
- The only CommandBehavior enumeration value that works with REF CURSOR data types (for example, when calling ExecuteReader) is CloseConnection; all others are ignored.
- The order of REF CURSOR columns in the OracleDataReader is dependent on the order of the parameters in the OracleParameterCollection. The ParameterName property is ignored.
- The PL/SQL TABLE data type is not supported by the Data Provider for Oracle. However, REF CURSOR data types are more efficient. If you must use a TABLE data type, use the OLE DB .Net Data Provider with MSDAORA.
Classes
| Class | Description |
|---|---|
| OracleBFile | Represents a managed OracleBFile object designed to work with the Oracle BFILE data type. This class cannot be inherited. |
| OracleCommand | Represents an SQL statement or stored procedure to execute against a database. This class cannot be inherited. |
| OracleCommandBuilder | Automatically generates single-table commands used to reconcile changes made to a DataSet with the associated database. This class cannot be inherited. |
| OracleConnection | Represents an open connection to a database. This class cannot be inherited. |
| OracleDataAdapter | Represents a set of data commands and a connection to a database that are used to fill the DataSet and update the database. This class cannot be inherited. |
| OracleDataReader | Provides a way of reading a forward-only stream of data rows from a data source. This class cannot be inherited. |
| OracleException | The exception that is generated when a warning or error is returned by an Oracle database or the .NET Framework Data Provider for Oracle. This class cannot be inherited. |
| OracleInfoMessageEventArgs | Provides data for the InfoMessage event. This class cannot be inherited. |
| OracleLob | Represents a Large Object Binary (LOB) data type stored on an Oracle server. This class cannot be inherited. |
| OracleParameter | Represents a parameter to an OracleCommand and optionally, its mapping to a DataColumn. This class cannot be inherited. |
| OracleParameterCollection | Represents a collection of parameters relevant to an OracleCommand as well as their respective mappings to columns in a DataSet. This class cannot be inherited. |
| OraclePermission | Enables the .NET Framework Data Provider for Oracle to help ensure that a user has a security level adequate to access an Oracle database. This class cannot be inherited. |
| OraclePermissionAttribute | Associates a security action with a custom security attribute. |
| OracleRowUpdatedEventArgs | Provides data for the RowUpdated event. This class cannot be inherited. |
| OracleRowUpdatingEventArgs | Provides data for the RowUpdating event. This class cannot be inherited. |
| OracleTransaction | Represents a transaction to be made at a database. This class cannot be inherited. |
Structures
| Structure | Description |
|---|---|
| OracleBinary | Represents a variable-length stream of binary data to be stored in or retrieved from a database. |
| OracleBoolean | Represents the value returned from a database comparison operation between Oracle data types, and exposes methods used to perform data type conversions. |
| OracleDateTime | Represents date and time data ranging in value from January 1, 4712 BC. to December, 31, 4712 AD. |
| OracleMonthSpan | Represents a time interval in months and corresponds to the Oracle 9i INTERVAL YEAR TO MONTH data type. |
| OracleNumber | Represents a fixed precision and scale numeric value between -1038 -1 and 10 38 -1 to be stored in or retrieved from a database. |
| OracleString | Represents a variable-length stream of characters to be stored in or retrieved from the database. |
| OracleTimeSpan | Represents a time interval and corresponds to the Oracle 9i INTERVAL DAY TO SECOND data type. |
Delegates
| Delegate | Description |
|---|---|
| OracleInfoMessageEventHandler | Represents the method that will handle the InfoMessage event of an OracleConnection. |
| OracleRowUpdatedEventHandler | Represents the method that will handle the RowUpdated event of an OracleDataAdapter. |
| OracleRowUpdatingEventHandler | Represents the method that will handle the RowUpdating event of an OracleDataAdapter. |
Enumerations
| Enumeration | Description |
|---|---|
| OracleLobOpenMode | Specifies whether an OracleLob should be opened in read/only or read/write mode. |
| OracleType | Specifies the data type of a field or property for use in an OracleParameter. |