capturing the error message while loading into oracle

[Edwink]

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

[ray.wurlod]

Execute the oerr command (perhaps in an External Filter stage) to decode the error, or query the Oracle system table that decodes error codes.

[prashkvrk]

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

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.

Prasad!

[Maveric]

See if this post by Vincent helps:
viewtopic.php?t=94683