Kbase P98851: Error (1455) when attempting to run a 4GL program against an Oracle Database using Oracle DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/09/2005 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
Oracle
SYMPTOM(s):
Error (1455) occurs when running a 4GL procedure against Oracle
WHERE clause buffer overflow. (1455)
Program being executed contains a WHERE clause on a large character field
The value of the large character field placed in the WHERE clause contains several space characters
CAUSE:
The run-time where clause buffer size used by the Oracle DataServer overflowed. The maximum size for this buffer is 4096 bytes
FIX:
Use the TRIM 4GL function to remove leading and trailing white space from the string of the large character field contained in the WHERE clause. e.g.:
FOR FIRST someDBTable WHERE TRIM(vcLargeFdl) = "Some Large String":U NO-LOCK.