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

In what product is WITH HOLD valid syntax? Certainly not Oracle. And what is it intended to accomplish?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)