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
