Thread: question about CURSOR

question about CURSOR

From
ivan
Date:
Hi, How can i check how many tules has my declared cursor ?
I can set absolute position in cursor , but i dont know how far can i go ?
I need it also to set size of my scroll .

One more question , when i use declare cursor to show select on grid,
better is to use cursor in BEGIN/END WORK, or WITH HOLD ?

thanks :)

bye



Re: question about CURSOR

From
Neil Conway
Date:
On Sun, 2003-10-12 at 05:42, ivan wrote:
> Hi, How can i check how many tules has my declared cursor ?

You can't know the # of tuples produced by a query without producing its
entire result set. Since DECLARE doesn't actually evaluate the query you
specify (... which is the whole point of using cursors to begin with),
it can't report the size of the query's result set.

> One more question , when i use declare cursor to show select on grid,
> better is to use cursor in BEGIN/END WORK, or WITH HOLD ?

I have no idea what this question means.

In any case, the current implementation of holdable cursors materializes
the cursor's result set when the cursor's creating transaction commits.
So it's not very high-performance for large result sets...

-Neil