Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

Re: using a cursor for loop with bulk collect?

From: ryan_gaffuri@xxxxxxxxxxx
To: Spikey.McMarbles@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 01 Oct 2004 15:25:13 +0000

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

Other related posts:

using a cursor for loop with bulk collect?