Kbase P134494: SQL: Error (7485) inserting a decimal value using parameters.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/27/2008 |
|
Status: Unverified
SYMPTOM(s):
SQL: Error (7485) inserting a decimal value using parameters.
Overflow error (7485)
Issue occurs when an ODBC or a JDBC client executes parameterized SQL statements to update decimal values.
Decimal values are either truncated or an Overflow error (7485) occurs.
Inserting the value:
.99999999999999999999999999999999999999999999999999
using parameters into a DECIMAL ( 50, 50 ) column generates error (7485).
Inserting the value:
.12345678901234567890123456789012345678901234567890
using parameters into a DECIMAL ( 50, 50 ) column truncates the value to:
.12345679000000000000000000000000000000000000000000
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1C
OpenEdge 10.1C01 Service Pack
CAUSE:
Bug# OE00167750
FIX:
Upgrade to OpenEdge 10.1C02 or later