Re: Exception halting a FORALL

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Mon, 26 Nov 2001 18:17:54 GMT
Message-ID: <3c028734.618685437@news.alt.net>

On Mon, 26 Nov 2001 09:56:11 GMT, John Russell <netnews_at_johnrussell.mailshell.com> wrote:

>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/

Nice to know. Thanx.

We are on 8i however. But 9i looks ever so nice.

Brian Received on Mon Nov 26 2001 - 12:17:54 CST