Export (0) Print
Expand All

System.Data.OracleClient Namespace

Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.

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.

Namespace hierarchy

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.

See Also

.NET Framework Class Library

Show:
© 2014 Microsoft