OracleType OracleType OracleType OracleType Enum

Definition

Specifies the data type of a field or property for use in an OracleParameter.

public enum class OracleType
public enum OracleType
type OracleType = 
Public Enum OracleType
Inheritance

Fields

BFile BFile BFile BFile 1

An Oracle BFILE data type that contains a reference to binary data with a maximum size of 4 gigabytes that is stored in an external file. Use the OracleClient OracleBFile data type with the Value property.

Blob Blob Blob Blob 2

An Oracle BLOB data type that contains binary data with a maximum size of 4 gigabytes. Use the OracleClient OracleLob data type in Value.

Byte Byte Byte Byte 23

An integral type representing unsigned 8-bit integers with values between 0 and 255. This is not a native Oracle data type, but is provided to improve performance when binding input parameters. Use the .NET Framework Byte data type in Value.

Char Char Char Char 3

An Oracle CHAR data type that contains a fixed-length character string with a maximum size of 2,000 bytes. Use the .NET Framework String or OracleClient OracleString data type in Value.

Clob Clob Clob Clob 4

An Oracle CLOB data type that contains character data, based on the default character set on the server, with a maximum size of 4 gigabytes. Use the OracleClient OracleLob data type in Value.

Cursor Cursor Cursor Cursor 5

An Oracle REF CURSOR. The OracleDataReader object is not available.

DateTime DateTime DateTime DateTime 6

An Oracle DATE data type that contains a fixed-length representation of a date and time, ranging from January 1, 4712 B.C. to December 31, A.D. 4712, with the default format dd-mmm-yy. For A.D. dates, DATE maps to DateTime. To bind B.C. dates, use a String parameter and the Oracle TO_DATE or TO_CHAR conversion functions for input and output parameters respectively. Use the .NET Framework DateTime or OracleClient OracleDateTime data type in Value.

Double Double Double Double 30

A double-precision floating-point value. This is not a native Oracle data type, but is provided to improve performance when binding input parameters. For information about conversion of Oracle numeric values to common language runtime (CLR) data types, see OracleNumber. Use the .NET Framework Double or OracleClient OracleNumber data type in Value.

Float Float Float Float 29

A single-precision floating-point value. This is not a native Oracle data type, but is provided to improve performance when binding input parameters. For information about conversion of Oracle numeric values to common language runtime data types, see OracleNumber. Use the .NET Framework Single or OracleClient OracleNumber data type in Value.

Int16 Int16 Int16 Int16 27

An integral type representing signed 16-bit integers with values between -32768 and 32767. This is not a native Oracle data type, but is provided to improve performance when binding input parameters. For information about conversion of Oracle numeric values to common language runtime (CLR) data types, see OracleNumber. Use the .NET Framework Int16 or OracleClient OracleNumber data type in Value.

Int32 Int32 Int32 Int32 28

An integral type representing signed 32-bit integers with values between -2147483648 and 2147483647. This is not a native Oracle data type, but is provided for performance when binding input parameters. For information about conversion of Oracle numeric values to common language runtime data types, see OracleNumber. Use the .NET Framework Int32 or OracleClient OracleNumber data type in Value.

IntervalDayToSecond IntervalDayToSecond IntervalDayToSecond IntervalDayToSecond 7

An Oracle INTERVAL DAY TO SECOND data type (Oracle 9i or later) that contains an interval of time in days, hours, minutes, and seconds, and has a fixed size of 11 bytes. Use the .NET Framework TimeSpan or OracleClient OracleTimeSpan data type in Value.

IntervalYearToMonth IntervalYearToMonth IntervalYearToMonth IntervalYearToMonth 8

An Oracle INTERVAL YEAR TO MONTH data type (Oracle 9i or later) that contains an interval of time in years and months, and has a fixed size of 5 bytes. Use the .NET Framework Int32 or OracleClient OracleMonthSpan data type in Value.

LongRaw LongRaw LongRaw LongRaw 9

An Oracle LONGRAW data type that contains variable-length binary data with a maximum size of 2 gigabytes. Use the .NET Framework Byte[] or OracleClient OracleBinary data type in Value.

When you update a column with the LONG RAW data type, an exception is thrown when you enter a value of null in the column. The Oracle LONG RAW data type is a deprecated type in Oracle version 8.0. To avoid this error, use the BLOB data type instead of LONG RAW.

LongVarChar LongVarChar LongVarChar LongVarChar 10

An Oracle LONG data type that contains a variable-length character string with a maximum size of 2 gigabytes. Use the .NET Framework String or OracleClient OracleString data type in Value.

NChar NChar NChar NChar 11

An Oracle NCHAR data type that contains fixed-length character string to be stored in the national character set of the database, with a maximum size of 2,000 bytes (not characters) when stored in the database. The size of the value depends on the national character set of the database. See your Oracle documentation for more information. Use the .NET Framework String or OracleClient OracleString data type in Value.

NClob NClob NClob NClob 12

An Oracle NCLOB data type that contains character data to be stored in the national character set of the database, with a maximum size of 4 gigabytes (not characters) when stored in the database. The size of the value depends on the national character set of the database. See your Oracle documentation for more information. Use the .NET Framework String or OracleClient OracleString data type in Value.

Number Number Number Number 13

An Oracle NUMBER data type that contains variable-length numeric data with a maximum precision and scale of 38. This maps to Decimal. To bind an Oracle NUMBER that exceeds what MaxValue can contain, either use an OracleNumber data type, or use a String parameter and the Oracle TO_NUMBER or TO_CHAR conversion functions for input and output parameters respectively. Use the .NET Framework Decimal or OracleClient OracleNumber data type in Value.

NVarChar NVarChar NVarChar NVarChar 14

An Oracle NVARCHAR2 data type that contains a variable-length character string stored in the national character set of the database, with a maximum size of 4,000 bytes (not characters) when stored in the database. The size of the value depends on the national character set of the database. See your Oracle documentation for more information. Use the .NET Framework String or OracleClient OracleString data type in Value.

Raw Raw Raw Raw 15

An Oracle RAW data type that contains variable-length binary data with a maximum size of 2,000 bytes. Use the .NET Framework Byte[] or OracleClient OracleBinary data type in Value.

RowId RowId RowId RowId 16

The base64 string representation of an Oracle ROWID data type. Use the .NET Framework String or OracleClient OracleString data type in Value.

SByte SByte SByte SByte 26

An integral type representing signed 8 bit integers with values between -128 and 127. This is not a native Oracle data type, but is provided to improve performance when binding input parameters. Use the .NET Framework SByte data type in Value.

Timestamp Timestamp Timestamp Timestamp 18

An Oracle TIMESTAMP (Oracle 9i or later) that contains date and time (including seconds), and ranges in size from 7 to 11 bytes. Use the .NET Framework DateTime or OracleClient OracleDateTime data type in Value.

TimestampLocal TimestampLocal TimestampLocal TimestampLocal 19

An Oracle TIMESTAMP WITH LOCAL TIMEZONE (Oracle 9i or later) that contains date, time, and a reference to the original time zone, and ranges in size from 7 to 11 bytes. Use the .NET Framework DateTime or OracleClient OracleDateTime data type in Value.

TimestampWithTZ TimestampWithTZ TimestampWithTZ TimestampWithTZ 20

An Oracle TIMESTAMP WITH TIMEZONE (Oracle 9i or later) that contains date, time, and a specified time zone, and has a fixed size of 13 bytes. Use the .NET Framework DateTime or OracleClient OracleDateTime data type in Value.

UInt16 UInt16 UInt16 UInt16 24

An integral type representing unsigned 16-bit integers with values between 0 and 65535. This is not a native Oracle data type, but is provided to improve performance when binding input parameters. For information about conversion of Oracle numeric values to common language runtime (CLR) data types, see OracleNumber. Use the .NET Framework UInt16 or OracleClient OracleNumber data type in Value.

UInt32 UInt32 UInt32 UInt32 25

An integral type representing unsigned 32-bit integers with values between 0 and 4294967295. This is not a native Oracle data type, but is provided to improve performance when binding input parameters. For information about conversion of Oracle numeric values to common language runtime (CLR) data types, see OracleNumber. Use the .NET Framework UInt32 or OracleClient OracleNumber data type in Value.

VarChar VarChar VarChar VarChar 22

An Oracle VARCHAR2 data type that contains a variable-length character string with a maximum size of 4,000 bytes. Use the .NET Framework String or OracleClient OracleString data type in Value.

Applies to