Re: Holdable cursors in Oracle?

On Wed, 19 Mar 2003 10:09:53 +0000, Billy Verreynne <vslabs_at_onwe.co.za> wrote:

>Hillel Eilat wrote:
>
>> Some DBMSs support a feature called "Holdable Cursors".
>>
>> A holdable cursor is kept open accross transaction boundaries,
>> as opposed to the 'normal' behavior of most known DBMS's.
><snipped>
>> Is there an equivalent / similar functionaly supported in Oracle?
>
>What is the reasoning, functionally and technically, behind such a concept?
to avoid parsing
>How are transactions from different users/sessions handled on this cursor
>and data integrity guaranteed?
>

A cursor exists *within* a session

>And how is this better than treating a table conceptually as a "holdable
>cursor"?
>
>Issues wrt to resource usage are moot IMO. I fail to see how these can
>dictate a fundemental concept such as holdable cursors.

They aren't. In fact in Pro*C, you can close a cursor and you can release it. If you don't release it, and only reevaluate it, you can save a parse.

>
>Not all problems are nails. ;-)

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Mar 19 2003 - 04:12:24 CST