RDBPROD: Integer Overflow on Fixed Point Numbers (Doc ID 973233.1)

Last updated on AUGUST 09, 2016

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.2 and later
HP OpenVMS Itanium
HP OpenVMS Alpha


Symptoms

When multiplying two BIGINTs which are defined as fixed-point numbers, e.g. as
B1   BIGINT(6)   and
B2   BIGINT(8)

the following exception may be reported unexpectedly:

%RDB-E-ARITH_EXCEPT, truncation of a numeric value at runtime
-COSI-F-ARITH, arithmetic exception
-COSI-F-INTOVF, integer overflow

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