Hello,
One of the Devs I work with brought up the use of DBMS_ALERT as a way to stop a process so it can continue after the user has done something.It does strike me as odd because I believe it should be 2 separate functions where one would go up to a certain part and after the user input I would call the second one.
Still, I haven't got experience with this functionality. Has anyone dealt with it in APEX? Is it worth to look use it in a web context? any warning or benefits worth mentioning?