Kbase P125105: Oracle data server append next field's value to a char field
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/25/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.x
SYMPTOM(s):
Oracle data server append next field value to a char field
Only happens with "for each" statement
Does not happen with "find" statement
Only happens with self serve client
Does not happen with client server environment
Issue does not happen if the next field's value does not get assigned in the same transaction
CAUSE:
This is a known issue
FIX:
There are three workarounds:
1. Use client server configuration, this configuration can be used even both the client and the server are on the same machine
2. Use "find" statement instead of "for each"
3. Do not assign the next field's value in the same transaction