Kbase P102292: Error 1453 in QUERY-PREPARE when WHERE clause is large
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/03/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
Oracle DataServer
SYMPTOM(s):
The WHERE clause for a dynamic query is very large (5,000+ characters)
When the QUERY-PREPARE method is invoked error 1453 is returned
Insufficient room in dbuf for insertop, op=<num>. (1453)
CAUSE:
The maximum size of the buffer for converting a 4GL WHERE clause into the equivalent SQL SELECT statement is 4,096 characters
FIX:
Reduce the size of the 4GL WHERE clause