Kbase P74587: Oracle numeric hits error 74 when negative
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Oracle numeric hits error 74 when negative
** Value <value> cannot be displayed using <format>. (74)
CAUSE:
Format for NUMERIC is missing one ">", as for example "->9.99" for NUMERIC (5,2).
Such a too short format is generated when using "Create DataServer Schema" or "Add/Update Table" utility.
FIX:
Change FORMAT in schema holder for the numeric column, adding an extra ">"