Kbase P145458: Oracle Dataserver: BLOB fields cause incorrect display of other fields in table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/05/2009 |
|
Status: Unverified
SYMPTOM(s):
Following query returns incorrect/truncated results for the fields created after the BLOB field:
FOR EACH <table-name> NO-LOCK:
DISPLAY charfield1, intfield1 <,...> EXCEPT blobfield1:
END.
Only fields CREATED AFTER the BLOB field are affected
FACT(s) (Environment):
Table contains one or more fields of BLOB datatype
In this example blobfield1 was created before charfield1 and intfield1
The same query using EXCLUSIVE-LOCK option displays correct results
Oracle 10g
All Supported Operating Systems
Oracle DataServer
OpenEdge 10.1C
CAUSE:
CR# OE00182856
FIX:
Upgrade to OE10.1C0308 or later