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.
Return Oracle SQLERROR
Moderators: chulett, rschirm, roy
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
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
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers