Float Field Values Could Be Too Big for Field Width But No Verification in Default Behavior
Last updated on MARCH 08, 2017
Applies to:Oracle Agile Engineering Data Management - Version 22.214.171.124 and later
Information in this document applies to any platform.
It should not be possible for end users to enter values too large for a float field and then receive a db error message if the value is too large for the field:
Internal Database Error in "dmi_upd_mas_elm" (EPSQL "EPQUPD") Code -910 OCI Error: -1438 / ORA-01438: value larger than specified precision allowed for this column.
For classification lists: Even though there might be no error message it is possible for end users to insert float values that do not fit into the field according to the field definition. Anyway, there is no error message because of the database precision.
This should be verified automatically and an appropriate message should be given without additional customizing (of for example cch_chk_rng).
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