Capture Ora Error in the reject link

dsscholar · Post by **dsscholar** » Tue Sep 13, 2011 4:49 am

Hello,

My job requirement is to insert data in Oracle database. In case any of the records is rejected, it should be captured in the reject file/table, irrespective of the reason, along with the Oracle Error Code and Message.

I was trying to use Oracle Enterprise Stage, but it I attach a reject link to it, it gives following compilation error:

"Error: Reject Link 'Oracle_Enterprise_25.DSLink20' is not allowed with the current setting (or lack) of the 'Write Method' property"

I don't see the output reject records option in the enterprise stage.

However if I try to use the Oracle Connector. I am able to compile the job but it doesn't reject the record. As soon it encouters a Null it aborts giving the Ora Code 01400 - rejected records are not written in the reject file.

I have tried setting the array size to 1. I also tried to specify the Ora Codes in APT_ORA_REJECT_CODES environment variable. But that environment variables is also not available in my project.

Any guidance/help is much appreciated.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 13, 2011 4:54 am

What's the value of the Write Method property?

dsscholar · Post by **dsscholar** » Tue Sep 13, 2011 6:05 am

I changed the write method to upsert and then could see the output reject option. I set it to true and was able to capture the records in reject file.

But if the write method is changed to upsert then how will the dupes be captured? Can someone please throw some light on this.

I can capture dupes earlier, but just wanted to know if there was some better way.

Thanks!