Re: How does a cursor get closed?

Have you tried to do it manually ?

close_cursor (cursor);

Robert :-)

<cowlesd_at_my-deja.com> skrev i melding news:8p3igo$8o5$1_at_nnrp1.deja.com...
> How does a cursor get closed?
>
> According to other documents on metalink, the
> close_cached_open_cursors parameter (which has been made an undocumented
> parameter
> in 8i) defaults to false, which means that
> cursors are held open across commits and rollbacks. I guess my
> question is, how do they get closed? I am interested in whether I should
> look into setting session_cached_cursors for certain jdbc activity
> that the developers are doing. From what I understand, this is helpful
> in
> forms, because as a user switches from one form to another, the old
> cursors will get closed. By what mechanism do cursors actually close,
> and also why does this happen with forms? If I'm not using forms, then
> how does a cursor get closed? If it's just an LRU kind of thing, then
> what am I gaining with session_Cached_cursors that I couldn't accomplish
> with just bumping up open_cursors?
>
> Thanks,
> Dc.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 06 2000 - 01:09:31 CDT