Page 1 of 1
Datastage warnings with Oracle
Posted: Wed Jun 04, 2014 1:22 pm
by abc123
Some Oracle errors are interpreted as warnings.
I know that I can set the warning limit to 1 so that the first warning is treated as an error no matter what the warning is for.
Is there a way to promote specific warnings to fatal errors?
Posted: Wed Jun 04, 2014 2:05 pm
by Damonsal
what is you requirement, why you want to do this way ?
Posted: Wed Jun 04, 2014 2:23 pm
by abc123
For specific Oracle errors such as unique constraint errors, I would like it be promoted to a fatal error on the first one.
Posted: Thu Jun 05, 2014 7:19 am
by abc123
Any thoughts any one? Is there anyway to may be capture the text of the warning and raise a fatal error from within a job?
Posted: Thu Jun 05, 2014 7:24 am
by chulett
Are you sure you need this only for certain warnings? I seem to recall an option in most Oracle stages to 'Treat warnings as Fatal', hence the question.
Posted: Thu Jun 05, 2014 7:41 am
by abc123
The Oracle stage has that option but that would be for all warnings. Is there any way to do this for specific warnings? Otherwise that's what I'll have to go with. Can I may be write a routine?