Consultor Eletrônico



Kbase P19653: Workaround when wrong data is retrived from Oracle for LONG
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   12/31/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

CAUSE:

Bug# 20030211-028

CAUSE:

Mixture between LOCKAHEAD and NO-LOOKAHEAD cursors on the client can make Oracle DS to retrive wrong value for large fields.

FIX:

Use NO-LOOKAHEAD with FOR EACH stataments or change FOR EACH statements without NO-LOOKAHEAD with a DO loop and FIND statements.