public enum OracleDbType : System.Enum, System.IComparable, System.IConvertible, System.IFormattable
'Declaration Public Enum OracleDbType Inherits System.Enum Implements System.IComparable, System.IConvertible, System.IFormattable
| Member | Description |
|---|---|
| AnyData | An ANYDATA TYPE contains an instance of a given type, plus a description of the type. In this sense, an ANYDATA is self-describing. An ANYDATA can be persistently stored in the database. |
| Array | An Oracle VARRAY data type representing a variable-length array. May be represented as the OracleArray class. This type does not have corresponding .NET Framework type. |
| BFile | An Oracle BFILE data type that contains a reference to binary data stored in an external file. May be represented as the OracleBFile class or array of System.Byte. |
| Blob | A LOB data type that contains a variable-length stream of binary data. Represented as the array of System.Byte. |
| Boolean | A simple type representing Boolean values of true or false. Corresponds to the server PL/SQL BOOLEAN type. |
| Byte | Corresponds to TT_TINYINT TimesTen type and NUMBER Oracle type. May be represented as the OracleNumber structure or System.Byte. |
| Char | A CHAR data type that contains a fixed-length character string. Represented as the System.String. |
| Clob | An Oracle CLOB data type that contains a variable-length character data. May be represented as the OracleLob class or the System.String. |
| Cursor | An Oracle REF CURSOR. This type does not have corresponding .NET Framework type. The OracleDataReader object can be used to retrieve cursor content. |
| Date | An Oracle DATE data type. May be represented as the OracleDate class. |
| Double | An Oracle NUMBER(p, s) [p >= 10 or s > 0] data type and BINARY_DOUBLE number data type of Oracle 10g that contains a double-precision floating-point value. A floating point type representing values ranging from approximately -1.79 x 10(308) to 1.79 x 10(308) with a precision of 15-16 digits. May be represented as the OracleNumber structure or the System.Double. |
| Float | An Oracle 10g BINARY_FLOAT number data type that contains a single-precision floating-point value. A floating point type representing values ranging from approximately -3.4 x 10(38) to 3.4 x 10(38). May be represented as the System.Single. |
| Int16 | Corresponds to TT_SMALLINT TimesTen type and NUMBER Oracle type. May be represented as the OracleNumber structure or System.Int16. |
| Int64 | Corresponds to TT_BIGINT TimesTen type and NUMBER Oracle type. May be represented as the OracleNumber structure or the System.Int64. |
| Integer | An Oracle NUMBER(p) [p < 10] data type that contains a signed 32-bit integers with values between -2147483648 and 2147483647. May be represented as the OracleNumber structure or the System.Int32. |
| IntervalDS | An Oracle INTERVAL DAY TO SECOND data type that contains an interval of time in days, hours, minutes, and seconds. May be represented as the OracleIntervalDS structure or the System.TimeSpan. |
| IntervalYM | An Oracle INTERVAL YEAR TO MONTH data type that contains an interval of time in years and months. May be represented as the OracleIntervalYM structure or the System.Int64. |
| Long | An Oracle LONG data type that contains a variable-length character string. May be represented as the OracleString structure or the System.String. |
| LongRaw | An Oracle LONG RAW data type that contains a variable-length stream of binary data. May be represented as the OracleBinary structure or array of System.Byte. |
| NChar | An Oracle NCHAR data type that contains a fixed-length national character string. May be represented as the OracleString structure or the System.String. |
| NClob | An Oracle NCLOB data type that contains a national variable-length character data. May be represented as the OracleLob class or the System.String. |
| Number | An Oracle NUMBER data type that contains variable-length numeric data with a maximum precision and scale of 38. May be represented as the OracleNumber structure or the System.Decimal. |
| NVarChar | An Oracle NVARCHAR data type that contains a variable-length national character string. May be represented as the OracleString structure or the System.String. |
| Object | One of the Oracle object types defined by the user. May be represented as the OracleObject class. This type does not have corresponding .NET Framework type. |
| Raw | An Oracle RAW data type that contains a fixed-length stream of binary data ranging between 1 and 4,000 bytes. May be represented as the OracleBinary structure or array of System.Byte. |
| Ref | An Oracle REF data type that contains a reference to the object. May be represented as the OracleRef class. This type does not have corresponding .NET Framework type. |
| RowId | The string representation of an Oracle ROWID data type. May be represented as the OracleString structure or the System.String. |
| Table | An Oracle NESTED TABLE data type, an unordered set of data elements, all of the same type. May be represented as the OracleTable class. This type does not have corresponding .NET Framework type. |
| TimeStamp | A TIMESTAMP data type that contains date and time, including seconds. Represented as the System.DateTime. |
| TimeStampLTZ | An Oracle TIMESTAMP WITH LOCAL TIMEZONE data type that contains date, time, and a reference to the original time zone. May be represented as the OracleTimeStamp structure or the System.DateTime. |
| TimeStampTZ | An Oracle TIMESTAMP WITH TIMEZONE data type that contains date, time, and a specified time zone. May be represented as the OracleTimeStamp structure or the System.DateTime. |
| VarChar | A VARCHAR data type that contains a variable-length character string. Represented as the System.String. |
| Xml | An Oracle XMLType type that contains XML data. May be represented as the OracleXml object. |
The next table shows mapping of System.Data.DbType members to OracleDbType.
| DbType member | Corresponding OracleDbType member |
|---|---|
| AnsiString | VarChar |
| AnsiStringFixedLength | Char |
| Binary | Blob |
| Byte | Integer |
| Boolean | Boolean |
| Currency | Number |
| Date | Date |
| DateTime | TimeStamp |
| DateTime2 | TimeStamp |
| DateTimeOffset | TimeStampTZ |
| Decimal | Number |
| Double | Double |
| Guid | Raw |
| Int16 | Integer |
| Int32 | Integer |
| Int64 | Number |
| Object | Object* |
| SByte | Integer |
| Single | Float |
| String | VarChar |
| StringFixedLength | Char |
| Time | IntervalDS |
| UInt16 | Integer |
| UInt32 | Number |
| UInt64 | Number |
| VarNumeric | Number |
| Xml | Xml |
*) OracleDbType is not actually assigned, it is determined later based on the OracleParameter.Value property.
System.Object
System.ValueType
System.Enum
Devart.Data.Oracle.OracleDbType
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2