Can't stop executing in SQL Window

MundeX

Member²
I can't stop executing in SQL Window. I tried tolbar button "Break" or Shift+Esc. Don't work!
I often executing script with over 10000 lines (mixed DDL, packed spec and body and other). Sometimes I had brake executing right now.
 
The Oracle Server will not always listen to break commands. For example when performing DDL, waiting for a lock, or performing internal sorts.
 
I known. I'm talking about the situation when execute many anonymous block BEGIN .... END;
For example:

Code:
BEGIN
(...)
END;
/
CREATE PACKAGE BODY ...
(...)
END;
/
BEGIN
(...)
END;
/
CREATE TABLE ....
/
DROP INDEX ....
(...)
(5000 line later)
(...)
<<< I want STOP executing HERE >>>
(...)
(5000 line later)
(...)
/
Sometimes I had to stop executing script on demand(after ORACLE finish executing current anonymous block or DDL of course). Somewhere in scripts.
 
Back
Top