Hi,
I have a parallel job to load the data into a table in Oracle database from the sequential file. I need to capture the records with SQL Error code in the reject file if the records are not loaded to the target table due to some SQL errors (say Duplicate Keys, Unique constraint).
Here is my job design
Seq file(source file) ------> Transforer ............> Oracle Table
From Transformer..............> Seqfile (Reject file)
Example - Scenario
source file is having 10 records with two duplicate records
Output
The reject file should contain those two duplicate records and the decription column in the reject file should have like "ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found"
Can anyone help me out on this problem...
Any solution for this problem is really appreciated.............
Thanks
Thiru
How to Capture SQL Error Codes when loading is failed
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 8
- Joined: Mon Jan 08, 2007 1:08 am
- Location: Trichy
-
- Participant
- Posts: 27
- Joined: Mon Jul 09, 2007 1:06 am
-
- Participant
- Posts: 8
- Joined: Mon Jan 08, 2007 1:08 am
- Location: Trichy