| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> 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
 |
 |