RDBPROD: Decimal Part Lost With Inserts/Updates of Scaled Integers (Doc ID 1319997.1)

Last updated on AUGUST 12, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.3 and later
Oracle 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();

Result:

SQL> select * from t2;
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