Scrollable cursors
Informix®
Informix SQL and Genero BDL support scrollable
cursors when you specify the
SCROLL clause in the DECLARE
cursor instruction:DECLARE c1 SCROLL CURSOR FOR SELECT ...ORACLE
Oracle OCI supports native scrollable cursors with the
OCI_STMT_SCROLLABLE_READONLY statement attribute.
Solution
The Oracle database driver uses native scrollable cursors by setting the
OCI_STMT_SCROLLABLE_READONLY statement attribute.