BreakExecution in a procedure

[abedran]

Hi!

I

 

[Marco Kalter]

I did a little test with the following procedure:

create or replace procedure infinite_loop is
begin
  loop null; end loop;
end;

I was able to break it just fine. Can you test something similar?

Note that if your procedure is waiting for a lock, of if it is performing SQL statements with internal sorts, it may not break or may not break immediately.

 

[abedran]

Hi!

It worked fine when I used your procedure.
It stopped immediately.
But when I use my procedure, it doesn

 

[Marco Kalter]

If your update is waiting for a lock, the break will not have any effect. You could kill the session of course by executing an ALTER SYSTEM KILL SESSION statement from another privileged session.

------------------
Marco Kalter
Allround Automations