Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

pl sql - How to set Oracle Concurrent Request Status = Error

705974Dec 10 2009 — edited Dec 10 2009
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!
This post has been answered by fsitja on Dec 10 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2010
Added on Dec 10 2009
4 comments
1,884 views