Progress
DataServer
for ORACLE Guide
Cursor Repositioning
With the DataServer, cursor repositioning will work with an ORACLE database the same as it does with Progress, except when the ORACLE Database Manager fails to find a record. In Progress, the cursor is located after the last record that was read. In ORACLE, a failed search does not affect the cursor. For example, if a cursor is positioned at cust-num 50 and a request to find customer “smith” in an ORACLE table fails, the cursor remains at cust-num 50. The same failed request from an Progress table places the cursor after the last customer read trying to find customer “smith”.
The DataServer repositions only cursors used by FIND NEXT/PREV/CURRENT statements. Cursors are never repositioned for FOR EACH statements or new queries. When the DataServer instructs the ORACLE RDBMS to perform a join (JOIN-BY-SQLDB), the cursor that the join uses does not reposition other cursors in use by the query. The cursor for a DEFINE QUERY statement does not reposition cursors in other queries.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |