Re: Which rows cause exception

Terry Dykstra wrote:
> 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?
>
>

Add an exception table and in the exception routine - insert the data in the exception table... Received on Thu Nov 20 2008 - 12:47:31 CST