Re: Scrollable cursors in Oracle 9i. Where is it?

in article 3c6d3157$0$3044$39cecf19_at_news.twtelecom.net, Felix A. Hernandez at cubano100pct_at_hotmail.com wrote on 2/15/02 8:06 AM:

> If Oracle advertizes Scrollable cursors feature, then they should implement
> fully at all layers.

Oracle's JDBC driver does support scrolling cursors via the resultset - see http://download-west.oracle.com/otndoc/oracle9i/901_doc/java.901/a90211/resl tset.htm#1018694 . In addition, ODBC and OCI also support scrolling cursors.

Interestingly enough, a large number of people at Oracle think the usage of scrolling cursors belie very bad application designs - and in fact scrolling cursor support has only been provided to comply with the ODBC and JDBC standards, primarily as an aid to people wanting to migrate their applications from Sybase and SQLServer to Oracle.

Given this, I wouldn't hold my breath for scrolling cursor support in PL/SQL - usage of the proper filter conditions and order by clauses on the cursor is a much more efficient approach than retrieving rows from the engine just to skip them programmatically. Received on Fri Feb 15 2002 - 21:54:24 CST