SQL & PL/SQL

Hi All,

We have a procedure that is processing millions of rows in a loop.

We want to stop execution of the procedure when it receives certain message (Ex: STOP).

Is there any way in Oracle where if the current executing procedure can be stopped in the middle if it receives certain message.

Note: We dont want to implement this approach by checking some table and check for the change of status, say RUN has been changed to STOP, Then exit the loop.

But this should be like, the procedure should be able to receive the message from outside and it should stop basing upon the message.

Appreciate your response.

Thanks,
Madhu K.