Re: Holdable cursors in Oracle?

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? How are transactions from different users/sessions handled on this cursor and data integrity guaranteed?

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.

Not all problems are nails. ;-)

--
Billy