I am trying to capture rejects from oracle enterprise stage while failure in inserting or updating the data into database table. Have tried with example data where actual data length exceeds the data length mentined in Database table.
My job is getting aborted with the following error.
But in practically am expecting this record as rejection thru reject link. I set Insert Array size as '1'.
I have raised this query long back on 7.5.1.A as well, where I was facing same issue and due to project timelines and all that stuff I changed my whole design without looking out for any solution.Oracle_Enterprise_100,2: Unable to insert a record into the table due to ORA-12899: value too large for column "Schema_Name"."TABLE_NAME"."SITE_ID" (actual: 7, maximum: 5)
So any body has got through with this sort of implementation.
Please share your ideas.