Kbase P128358: FIND statement only returns first 4096 chars of a LONG field with Oracle 9.2.0.1
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/01/2008 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1x
Oracle DataServer
Oracle 9i
SYMPTOM(s):
Oracle 9.2.0.1
Querying table containing field with LONG data type
Field contains more than 4096 characters
FIND statement only returns first 4096 characters
Oracle reports an error in dataserv.lg
ORA-24345: A Truncation or null fetch error occurred ----
Different query types and options return different results
Correct results (all characters) returned by following statements:
FOR EACH <table> - no error in log
FOR EACH <table> QUERY-TUNING(LOOKAHEAD) - no error in log
FOR FIRST <table> - ORA-24345 in log
FOR FIRST <table> QUERY-TUNING(LOOKAHEAD) - ORA-24345 log
Incorrect results (first 4096 characters) returned by following statements:
FIND FIRST <table>
FOR FIRST <table> QUERY-TUNING(NO-LOOKAHEAD)
FOR EACH <table> QUERY-TUNING(NO-LOOKAHEAD)
Problem does not occur in Oracle 9.2.0.8
Problem does not occur in Oracle 10g
CAUSE:
Oracle OCI bug
FIX:
Upgrade to Oracle 9.2.0.8
Upgrade to Oracle 10g or later