Kbase P50514: GET NEXT with qt_no_lookahead grabs the wrong row in Oracle
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/17/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
Oracle DataServer
Oracle
SYMPTOM(s):
Oracle DataServer retrieves an incorrect row
Using the -Dsrv qt_no_lookahead parameter in the foreign database connection string to connect to Oracle
Specifying the INDEXED-REPOSITION option with the OPEN QUERY Statement
Repositioned to a record in the query's result set via the Progress REPOSITION TO ROWID statement
Executing the GET NEXT command after the index REPOSITION
Unable to specify a BY clause with the OPEN QUERY Statement
Cannot use PRESELECT instead of FOR with the OPEN QUERY Statement
Unable to remove the INDEXED-REPOSITION option from the OPEN QUERY Statement
CAUSE:
Bug# OE00092679
FIX:
Upgrade to Progress 9.1D08 or later