Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Server-side cursors

15637Oct 30 2001
Is there any version of the Oracle ODBC driver that supports
true server-side cursors? If so, how do you specify that you
want a server-side cursor?

Comments

JustinCave
No. The Oracle database doesn't, as best I know, support server-
side cursors in the way SQL*Server does, so it isn't really
possible to implement this functionality in Oracle.

Justin
15637
Thanks for the response. A follow-up question then is - is there
any way to not force the download of large volunes of data to
the client box? We have a fairly large database that we are
accessing, and would like to only retrieve the chunks of
information of current interest.
5725
Thanks for the response. A follow-up question then is - is
there
any way to not force the download of large volunes of data to
the client box? We have a fairly large database that we are
accessing, and would like to only retrieve the chunks of
information of current interest.
The only method I have found is to append "AND ROWNUM < 100" to
the WHERE clause on the SELECT statement.
If a better method exists I'd love to here about it.
/Mats
JustinCave
Are you fetching the data directly via ODBC, or are you using
some sort of higher-level API? The ODBC SQL[Extended]Fetch
operations should allow you to fetch data n rows at a time
(where n is an arbitrary integer). It's possible that your
higher-level API isn't smart enough to take advantage of this...

Justin
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 28 2001
Added on Oct 30 2001
#odbc, #windows-and-net
4 comments
463 views