Microsoft ADO.NET 与 Oracle ODP.NET

Microsoft (OracleType)  - ODP.NET (OracleDbType) 类型参照

Oracle Data Type	ODP.NET (OracleDbType)	Microsoft (OracleType)
BFILE	BFile	BFile
BLOB	Blob	Blob
byte	Byte	Byte
CHAR	Char	Char
CLOB	Clob	Clob
DATE	Date	DateTime
8-byte FLOAT	Double	Double1
2-byte INTEGER	Int16	Int16
4-byte INTEGER	Int32	Int32
8-byte INTEGER	Int64	N/A
INTERVAL DAY TO SECOND	IntervalDS	IntervalDayToSecond
INTERVAL YEAR TO MONTH	IntervalYM	IntervalYearToMonth
LONG	Long	LongVarChar
LONG RAW	LongRaw	LongRaw
NCHAR	NChar	NChar
NCLOB	NClob	NClob
NUMBER	Decimal	Number
NVARCHAR2	NVarchar2	NVarChar
RAW	Raw	Raw
REF CURSOR	RefCursor	Cursor
ROWID	N/A	RowId
4-byte FLOAT	Single	Float1
TIMESTAMP	TimeStamp	Timestamp
TIMESTAMP WITH LOCAL TIME ZONE	TimeStampLTZ	TimestampLocal
TIMESTAMP WITH TIME ZONE	TimeStampTZ	TimestampWithTZ
VARCHAR2	Varchar2	VarChar
		SByte1
		UInt161
		UInt321

详情见：http://msdn.microsoft.com/en-us/library/ms971518.aspx

oracle odp.net 32位/64位版本的问题及下载地址：http://www.cnblogs.com/yjmyzz/archive/2011/04/19/2020793.html