friends,
i am using oracle stage to load the records into oracle Db .while loading, few records got rejected due to some reason.currently we are getting sql error code from the reject link,but i need to collect the message(reason for rejection) in a file.
please advice
capturing the error message while loading into oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: capturing the error message while loading into oracle
in the target table set "output reject records as true". Then use a transformer stage after the target table. You will get a new column with name "sql code". u can collect this information in a sequential file. so you can get the sql error code. Now since you know the error code, depending on the error code write what ever reject reason you get based on the error code. This can be achieved by generating a new column say "reject reason" in the transformer.Edwink wrote:friends,
i am using oracle stage to load the records into oracle Db .while loading, few records got rejected due to some reason.currently we are getting sql error code from the reject link,but i need to collect the message(reason for rejection) in a file.
please advice
Prasad!
See if this post by Vincent helps:
viewtopic.php?t=94683
viewtopic.php?t=94683