Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Exception halting a FORALL

Re: Exception halting a FORALL

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Fri, 23 Nov 2001 04:36:13 GMT
Message-ID: <1nkL7.34682$xS6.59421@www.newsranger.com>


Hi Brian,
it seems that there is no solution in your case. FORALL statement is atomic statement so you can't to process exceptions inside.

In article <3bfda63a.298947875_at_news.alt.net>, Brian Tkatch says...
>
>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.
[SKIPPED]

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com
Received on Thu Nov 22 2001 - 22:36:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US