Kbase P99088: A Stored Procedure produces error 7485 when using the SUM function on Float columns.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/12/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
A Stored Procedure produces error 7485 when using the SUM function on Float columns.
Overflow error (7485)
Random Float data is inserted from within a Stored Procedure.
Using Java Float objects to update SQL Float columns.
CAUSE:
The Stored Procedure is passing in Java Float objects which should have been Java Double objects.
FIX:
As documented in table 5-2 of the "SQL-92 Guide and Reference", the SQL Float data type is mapped to the Java Double data type.