Kbase P103797: Error 1455 when retrieving record from an Oracle table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/07/2005 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Error 1455 when retrieving record from an Oracle table
WHERE clause buffer overflow. (1455)
Program being executed contains a WHERE clause on a character field X(1024)
The value of the large character field placed in the WHERE clause contains more than 998 characters
CAUSE:
This is a known issue being investigated by Development
There is a 998 characters limit imposed by an internal buffer used to place each single value that has to be added to the WHERE clause.
FIX:
As a workaround, use the TRIM function in the WHERE clause.
For example:
DEFINE VARIABLE LongValue AS CHARACTER NO-UNDO.
LongValue = FILL("a",1024).
FIND FIRST Table WHERE TRIM(Table.LongField) = LongValue.