Skip to Main Content

APEX

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!

kill infinite loop stored procedure from Apex Cloud without access to v$session/v$process

stefano zaglioMar 12 2025

Hi,

even if I try to program perfectly sometimes an infinite loop happens. After a few minutes Oracle kills the procedure by itself but this causes two problems.

The first is that I have to wait.

The second is that I wonder what would happen if I had to run a very long process or one that remains in an infinite loop by polling some source.

Thanks
s.

Comments
Post Details
Added on Mar 12 2025
3 comments
253 views