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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
