large query, Initializing problem

[derik82]

Hi Everyone,

I know there was a thread on this issue, but I cant find the solution in it.

I use PL/SQL Developer
Version 10.0.5.1710
01.89618 - 10 user license
Windows 8 (64-bit) 6.2 Build 9200

when I want to run large query, the "Initializing" take very long.
I want to run now a simple set of insert statement approximately 1000 inserts, the initialization takes endless time. Even at the end the pl/sql developer freezez.

Please can you help me how to fix this,

Thanks
Best Regards,
Derik82

 

[Marco Kalter]

If you are doing this in the SQL Window it is best to place all the insert statements in a begin/end block:

begin
  insert ...;
  insert ...;
end;

 

[derik82]

Hi, thank you.

I just wondering how is it possible, that such a tool like pl/sql developer, can't run 100 insert statement without problem. What is it initializing? Will be there a fix?

regards,
szilard

 

[Marco Kalter]

The SQL Window is an interactive tool to run a limited number of SQL statements and manipulate the results. It is not designed to run massive batch scripts. For this purpose you should preferably use the Command Window.

 

[derik82]

Thank you!

 

[dhivya@settu]

product code and key is not coming