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>
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 DykstraReceived on Thu Nov 20 2008 - 09:58:43 CST