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

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

Re: WITH HOLD cursors in Oracle stored procs

From: Aakash <bordia_at_gmail.com>
Date: 20 Jan 2006 10:28:18 -0800
Message-ID: <1137781698.329755.316220@g43g2000cwa.googlegroups.com> 





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
Received on Fri Jan 20 2006 - 12:28:18 CST












Original text of this message













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