I have a business-flow consisting of several steps implemented as stored procedures in Oracle. I want wrap the whole flow, which is linear (Step1 -> Step2 -> Step3 ->...) into a job that will run monthly.
The problem is that some of these steps are critical, and when they fail, I want the job to end with status FAILED, and issue an alert to my email. I thought a good approach would be to use RAISE_APPLICATION_ERROR when my validations fail, thus also transmitting a custom error message.
My question is, if I call RAISE_APPLICATION_ERROR in any of the procedures (and not catching it externally), will the job automatically fail, abort (end) and alert? (in the same manner as an uncaught exception causes a program to crash).