OracleNumber and OracleDateTime

Question

User-592976280 posted

This link http://msdn.microsoft.com/zh-tw/library/system.data.oracleclient.oracledatareader%28v=VS.100%29.aspx uses
OracleNumber and OracleDateTime in the example. When I use those in .net 4.0 and vs2010, I get compilation error about not found.
It doesn't error and works fine when I use OracleDecimal and OracleString though. So I don't think I'm missing an assembly.
Any suggestion? Thanks.

Answer 1

User269602965 posted

In .NET 4.0,

I always use DECIMAL asp.net datatype to pass numbers

and DATETIME asp.net datatype to pass dates.

Change from System.Data.OracleClient to Oracle.DataAccess.Client

I found it faster, and intellitype gives me more Oracle parameter datatypes to try.

 

Answer 2

User-592976280 posted

Thank you.