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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: using a cursor for loop with bulk collect?

Re: using a cursor for loop with bulk collect?

From: <ryan_gaffuri_at_comcast.net>
Date: Fri, 01 Oct 2004 15:25:13 +0000
Message-Id: <100120041525.15387.415D76D8000C183100003C1B2200734076079D9A00000E09A1020E979D@comcast.net>


through 9.2 open,fetch, close is required. haven't checked version 10. -------------- Original message --------------
> I'm setting up a procedure to purge old data from an application
> table. For keep the run-time manageable, I'm fetching the relevant
> rowids with an explicit cursor, using the BULK COLLECT clause. Once
> the relevant rows have been identified, I'm using FORALL to perform a
> bulk delete. This seems to be working well, but it got me curious...
>
> Is it possible to do bulk collections via a CURSOR FOR loop, or is the

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 01 2004 - 10:20:51 CDT

Original text of this message

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