Command Window hangs when running scripts from files

[Ameen]

Hi.
I am using PL SQL Dev version 11, database version 10g (10.2.0).
When I use Command Window to install scripts from files, it hangs and does not continue the installation scripts. It does not stop at the same place in the script, sometimes after 10 commands and sometimes after 20 commands, for example if the file contains INSERT commands (all commands are the same) it stops after a while and I need to terminate it or force-close it and restart the job using SQL PLUS program.
This error exited in version 10 and now the same error still exist in version 11.
Note: the error occur no matter what is in the files, it hangs with all types of commands (alter table, INSERT, UPDATE, create trigger ....) .

 

[Marco Kalter]

We'll investigate.

 

[Ameen]

Still exists in v 11.02

 

[Ameen]

I think there is a clue to identify the problem.
I used a script like the following example:

create user uuu identified by uuu
default tablespace user
temporary tablespace temp;
grant xxx to yyy;
-- comment line goes here...
grant zzz to yyy;
grant ddd to yyy;
...
many grants here...
...
grant ggg to yyy;

the window hangs after some lines , no specific line, sometimes it hangs after 3 lines, somtimes after 6 ... etc.
but if I delete comments lines, arrange each command to be in one line only as the following example:

create user uuu identified by uuu default tablespace user temporary tablespace temp;
grant xxx to yyy;
grant zzz to yyy;
grant ddd to yyy;
...
many grants here...
...
grant ggg to yyy;

then the script runs until the end.
So In my opinion , the problem could be in parsing the commands, or in the response taken from database after posting parts of one command (line by line).
I hope this help you to solve the problem.

 

[Ameen]

I think there is a new clue to identify the problem: Command-Window's session always hanged and still exists even after force shut the window! it seems that there is a problem concerning "Locking" mechanism when passing commands to database. Some commands "waits" the lock from previous command to get away but that lock wont be gone even after force shut the window or entire PLD window.
Sometimes where there is an error message from one command, the next command hangs too. It seems it is related to some buffer issues or cleaning things after executing each command.

 

[Ameen]

This is true in version 11.0.5 too.

 

[Ameen]

I remember this was not an issue in version 7, it seems it has to do with multi-connections feature in PLD, though I set the preferences "allow multiple connections" to "no" but the same problem appears again and again.