DSXchange

Posted: **Sat Jan 19, 2008 4:58 am**

Hi,

Any Function to get oracle Error Description in DataStage.

By using DBMSCODE we are getting Errorno:ORA917

Belong's that How to Capture Oracle Error Description as well

Please Let me know the way?

Thanks in Advance
Srini

Posted: **Sat Jan 19, 2008 5:37 am**

There is no routine "out of the box". However you could invoke the oerr command through your own routine via DSExecute subroutine.

Posted: **Sat Jan 19, 2008 9:04 am**

Or create a reference hashed file with the values you are interested in and lookup when rejecting.