Which rows cause exception

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Thu, 20 Nov 2008 15:58:43 GMT
Message-ID: <TOfVk.1896$jr4.1047@edtnps82>


Oracle 9.2.05 SE

In a stored procedure I have code like this:

INSERT INTO DPRS_WELL (PRODUCTION_MONTH,UWI,....) SELECT ad_prod_date,UWI,...
  FROM DPRS_WELL_LOAD
 WHERE PRODUCTION_MONTH = add_months(ad_prod_date,-1);

EXCEPTION
WHEN DUP_VAL_ON_INDEX THEN

     RAISE_APPLICATION_ERROR(-20001,'Duplicate UWI', true);
WHEN VALUE_ERROR THEN
     RAISE_APPLICATION_ERROR(-20002,'Value error', true);


Is there any way I can determine in the exception block which row(s) caused the exception?

-- 
Terry Dykstra 
Received on Thu Nov 20 2008 - 09:58:43 CST

Original text of this message