Last updated on AUGUST 12, 2016
Applies to:
Oracle Rdb Server on OpenVMS - Version 7.3 and laterOracle Rdb Developer Tools for Visual Studio - Version 7.3 to 7.3.2.0 [Release 7.3]
Information in this document applies to any platform.
Symptoms
Insert or update of INTEGER(n) or BIGINT(n) fields are loosing the decimal part when the DbType Decimal is used, for example:
cmd.CommandText = "Insert into t1(c1) values (@d_value)";
RdbParameter prm1 =
cmd.Parameters.Add(new RdbParameter("@d_value", System.Data.DbType.Decimal));
prm1.Value = 1.234;
cmd.ExecuteNonQuery();
RdbParameter prm1 =
cmd.Parameters.Add(new RdbParameter("@d_value", System.Data.DbType.Decimal));
prm1.Value = 1.234;
cmd.ExecuteNonQuery();
Result:
SQL> select * from t2;
C1
1.0000
C1
1.0000
This occurs only if the connection type is SQS, not with THIN.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms