Re: pl/sql exception processing ?

From: Peter H. Larsen <plen_at_novo.dk>
Date: 1997/10/27
Message-ID: <3454898F.AC430350@novo.dk>#1/1

Hi Tlcbus,
Yep - no problem, if you have an anonymous block within the loop and handle the exception in there:

FOR W1 IN CURSOR_1 LOOP
  BEGIN
    INSERT INTO .... VALUES .....;
   EXCEPTIONS

     WHEN DUP_VAL_ON_INDEX THEN
         <do something>;

END;
END LOOP;

Peter H. Larsen

Tlcbus wrote:

> To all:
>
> Winin a cursor loop loaing data, my exception section will handle duplicate
> record and after log a message, is it possible to continue back to loop and
> processing next record.
>
> Thanks in advance Ted chyn
Received on Mon Oct 27 1997 - 00:00:00 CST