DSXchange

I am trying to write the errored records to another target table/file. I need to know if I can call the ORACLE's built-in SQLERR exception in my transformer and track the records that failed with the SQLERR and SQLERRM.

Please advise.

Welcome!

Off the top of my head, I know you can get the SQLERR from Oracle by referring to the DBMSCODE Output Link Variable in the Transformer handling the rejects. Not sure about the SQLERRM, but you could try some of the other Variables there and see if one might suit your needs. They are:

LASTERR
REJECTED
REJECTEDCODE
SQLSTATE

I appreciate your help!

Thanks