Re: No. of rows on result set

On Jul 14, 2005, at 5:10 PM, Oliver Jowett wrote:
> If you need to use last(), then TYPE_SCROLL_INSENSITIVE is the way to
> go.
>
> Note that this means the driver will retrieve the entire resultset in
> one go rather than possibly using cursors (if you've set fetchsize and
> have autocommit off) -- you might have problems with big resultsets. If
> so I'd go with COUNT.

Ok, looking at the apps, the query either returns one row or a large
resultset. But using TYPE_SCROLL_INSENSITIVE should not be a problem
because fetchsize is not set and autocommit is not off.

Thank you so much for the great help.

Dianne