Re: WITH HOLD cursors in Oracle stored procs

Aakash wrote:
> Is it possible for a stored proc written in PL/SQL to return a
> refcursor which is WITH HOLD? I tried the following syntax:
> OPEN RS WITH HOLD FOR SELECT...
>
> Any help welcome!
> Thanks
> Aakash\

If you're attempting to prevent updates to data selected by that cursor then you would write your cursor select as: select ..... for update [ of ....];

There is no 'WITH HOLD' option for opening a cursor in Oracle.

David Fitzjarrell Received on Thu Jan 19 2006 - 22:39:46 CST