I have created a job, which accepts parameters and based upon that it retrieve data from Oracle Table. Now I want to know how Can I handle no_data_found exception... Currently it is executing succesfully but I want to abort the job when it is unable to find the data based upon parameters.. Any help will be highly appreciated.
Thanks,
Gulshan
Oracle No data Found
Moderators: chulett, rschirm, roy
If you mean zero rows returned, then use job control API calls and the check the link statistics after the job has run. If no rows were processed, then take appropriate action.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle