Kbase P19652: Wrong data is retrived from Oracle for LONG data type fields
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/10/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Wrong data is retrived from Oracle for LONG data type fields
Using a standard FOR EACH with a WHERE clause on the first of a two-part key
Field is 16000 bytes big
Other fields in the same record are correct.
No other users are modifying this particular record, although other users are certainly modifying other records in the same table
Performing the same FOR EACH multiple times will many times give correct results, but sometimes pull the long field from an entirely different record.
Using a FIND in lieu of the FOR EACH does not display the behavior
using a FIND in lieu of the FOR EACH does not display the behavior
The same code always works correctly when executed from Procedure Editor but producing incorrect results through Webspeed under heavy load
CAUSE:
Bug# 20030211-026
FIX:
Apply 9.1D06