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 [Release 7.3]
Information in this document applies to any platform.


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;


SQL> select * from t2;

This occurs only if the connection type is SQS, not with THIN.


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