Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: WITH HOLD cursors in Oracle stored procs

Re: WITH HOLD cursors in Oracle stored procs

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 20 Jan 2006 11:48:54 -0800
Message-ID: <1137786523.176871@jetspin.drizzle.com>


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)
Received on Fri Jan 20 2006 - 13:48:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US