I registered a custom pl sql block as an Oracle Concurrent Request. I want to raise an EXCEPTION that will make the job end in an ERROR status if a condition is met. How can I do this? Here's an excerpt of the code I have:
EXCEPTION
WHEN v_nodata THEN
<what command can I put here? I want the concurrent request job to error so that the next pl sql block doesn't get executed.>
when OTHERS THEN NULL;
END;
/
Thanks!