Re: WITH HOLD cursors in Oracle stored procs

Aakash wrote:
> This WITH HOLD syntax is valid in DB2. It is used to :
> Maintains resources across multiple units of work. For units of work
> ending with COMMIT:
> Open cursors defined WITH HOLD remain open. The cursor is positioned
> before the next logical row of the results table.
> This is what I wanted to achieve.
>
> Thanks
> Aakash

Since Oracle cursors are unaffected by COMMITs there appears to be no point in this exercise.

Perhaps you should spend your time reading Oracle documentation and specifically books by Tom Kyte, Jonathan Lewis, and members of The Oak Table.

Additional Advise: Oracle is not just a different brand of DB2 and to post DB2 syntax without explanation is essentially a waste of everyone's time.

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