dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleDbType Enumeration

In This Topic
    OracleDbType Enumeration
    In This Topic
    Specifies the data type of a field, property, OracleParameter or OracleAttribute.
    Syntax
    'Declaration
     
    Public Enum OracleDbType 
       Inherits System.Enum
       Implements System.IComparableSystem.IConvertibleSystem.IFormattable 
    Members
    MemberDescription
    AnyDataAn 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.
    ArrayAn 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.
    BFileAn 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.
    BlobA LOB data type that contains a variable-length stream of binary data. Represented as the array of System.Byte.
    BooleanA simple type representing Boolean values of true or false. Corresponds to the server PL/SQL BOOLEAN type.
    ByteCorresponds to TT_TINYINT TimesTen type and NUMBER Oracle type. May be represented as the OracleNumber structure or System.Byte.
    CharA CHAR data type that contains a fixed-length character string. Represented as the System.String.
    ClobAn Oracle CLOB data type that contains a variable-length character data. May be represented as the OracleLob class or the System.String.
    CursorAn Oracle REF CURSOR. This type does not have corresponding .NET Framework type. The OracleDataReader object can be used to retrieve cursor content.
    DateAn Oracle DATE data type. May be represented as the OracleDate class.
    DoubleAn 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.
    FloatAn 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.
    Int16Corresponds to TT_SMALLINT TimesTen type and NUMBER Oracle type. May be represented as the OracleNumber structure or System.Int16.
    Int64Corresponds to TT_BIGINT TimesTen type and NUMBER Oracle type. May be represented as the OracleNumber structure or the System.Int64.
    IntegerAn 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.
    IntervalDSAn 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.
    IntervalYMAn 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.
    LongAn Oracle LONG data type that contains a variable-length character string. May be represented as the OracleString structure or the System.String.
    LongRawAn 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.
    NCharAn Oracle NCHAR data type that contains a fixed-length national character string. May be represented as the OracleString structure or the System.String.
    NClobAn Oracle NCLOB data type that contains a national variable-length character data. May be represented as the OracleLob class or the System.String.
    NumberAn 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.
    NVarCharAn Oracle NVARCHAR data type that contains a variable-length national character string. May be represented as the OracleString structure or the System.String.
    ObjectOne 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.
    RawAn 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.
    RefAn 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.
    RowIdThe string representation of an Oracle ROWID data type. May be represented as the OracleString structure or the System.String.
    TableAn 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.
    TimeStampA TIMESTAMP data type that contains date and time, including seconds. Represented as the System.DateTime.
    TimeStampLTZAn 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.
    TimeStampTZAn 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.
    VarCharA VARCHAR data type that contains a variable-length character string. Represented as the System.String.
    XmlAn Oracle XMLType type that contains XML data. May be represented as the OracleXml object.
    Remarks
    This table shows mappings between OracleDbType values, Oracle data types, Microsoft .NET Framework types.

    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.

    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             Devart.Data.Oracle.OracleDbType

    Requirements

    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

    See Also