Re: Continue on Exception

Gnomic wrote:
>
> Paul Brooks <P.A.Brooks_at_btinternet.com> wrote in article
> > exception
> > when dup_val_on_index then
> > null;
>
> Thanks Paul (and others).
>
> That's exactly what I did the first time. And at the first exception, it
> said "PL/SQL competed successfully" and exited.Hmmm.... I thought I was
> missing something. <whap! (sound of forehead hitting screen)> Time to dig a
> bit deeper...

Two questions spring to mind:-

1. Did you commit afterwards?
2. Is the exception handler within the loop (where it needs to be) or at the end of the block?

Sj Received on Wed Dec 24 1997 - 00:00:00 CET