Any Function to get oracle Error Description in DataStage

ysrini9 · Post by **ysrini9** » 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

ray.wurlod · Post by **ray.wurlod** » 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.

chulett · Post by **chulett** » Sat Jan 19, 2008 9:04 am

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