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: 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