Page 1 of 1

Oracle No data Found

Posted: Thu Apr 15, 2004 4:10 pm
by gulshanr
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

Posted: Thu Apr 15, 2004 7:43 pm
by kcbland
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.