Exception Handling
Posted: Thu Sep 25, 2008 9:08 am
Hi,
I am trying to design a job such that if an exception occurs it should write to a file or table
i.e Out of 4 rows from source 2 rows have Varchar2(15) and other 2 rows have Varchar2(12), and the target has a structure of Varchar2(12).
When job runs it throws the warning saying inserted value too large. Now i want the other two rows to be inserted into table and the bad record (ie of length varchar2(15)) should be written to a file or table.
To be simple i have to do an Exception Handling like in Stored Procedure
I am trying to design a job such that if an exception occurs it should write to a file or table
i.e Out of 4 rows from source 2 rows have Varchar2(15) and other 2 rows have Varchar2(12), and the target has a structure of Varchar2(12).
When job runs it throws the warning saying inserted value too large. Now i want the other two rows to be inserted into table and the bad record (ie of length varchar2(15)) should be written to a file or table.
To be simple i have to do an Exception Handling like in Stored Procedure