Re: Exception halting a FORALL

On Fri, 23 Nov 2001 01:31:44 GMT,
SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK (Brian Tkatch) wrote:

>From the docs.
>
>"When any execution of the SQL statement raises an exception, the
>FORALL statement halts."
>
>Is there anyway around that, other than creating a normal loop.

In 9i there is the BULK%EXCEPTIONS attribute that lets you go through the whole loop, ignoring exceptions, and then process the rows that threw exceptions afterwards:

http://tahiti.oracle.com/pls/db901/db901.drilldown?remark=&word=bulk%25exceptions&book=&preference=

John

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/