Oracle DataType

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have a variable described in Oracle as NUMBER(6) or NUMBER(4) what
datatype does this translate into when I am building a parameter? There is
no "Number" data type to select from when I am populating
"Oracle.DataAccess.Client.OracleDataType". When does the number become INT16
vs. INT32 vs INT64? I read that Oracle natively stores these as
decimal....but I maybe all wet on this one..

Thanks in advance for your assistance!!!!!!!
 
Jim said:
If I have a variable described in Oracle as NUMBER(6) or NUMBER(4) what
datatype does this translate into when I am building a parameter? There is
no "Number" data type to select from when I am populating
"Oracle.DataAccess.Client.OracleDataType". When does the number become
INT16 vs. INT32 vs INT64? I read that Oracle natively stores these as
decimal....but I maybe all wet on this one..
Click to expand...

Use this list:

0 < scale < 255:
precision > 15: Decimal
precision > 7: double
else: single

scale = 0:
precision < 5: Int16
precision <10: Int32
precision <19: Int64
else: decimal.


FB
 
Back
Top