Kbase P32130: Find record with Oracle DataServer produces error 2318
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/09/2008 |
|
Status: Verified
SYMPTOM(s):
Find record with Oracle DataServer produces error 2318
ORACLE failed to convert a number to a 4 bytes integer.
You probably chose a RECID column which holds a value larger than 4 bytes values. (2318)
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
Oracle DataServer
CAUSE:
Progress writes error 1318 when oracle error 1455 is caught, Oracle error 1455 is following
01455, 00000, "converting column overflows integer datatype" definition of that field."
The Progress_recid column is defined as integer therefore is overflowing with large value
FIX:
Change Progress_recid definition as number(12,0).