When running PL/SQL programs application control is lost as Toad is processing/executing the program. A Processing Script message is up and prevent me from doing any work in Toad.
Example:
Run the following script. It will bring up a Processing Script message and will lock down Toad so that no other window or tab can be accessed until the process is finished.
DECLARE
x1 NUMBER;
v1 VARCHAR2(100);
d1 DATE;
BEGIN
FOR i IN 1 .. 10000000
LOOP
x1 := i * 9999.999999999/9.993453345/9.990909999/1.23423423;
END LOOP;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE ('ERRORx:: '||SQLCODE||' - '||SUBSTR(TRIM(SQLERRM), 1, 225));
END;
The Processing Script message and lock down of Toad is to show the session is busy with a process and this is by design in Toad to avoid conflicts if another program is allowed to be executed.
