Hello,
I have a problem with a PL/SQL Developer project, where several pdc-files are called, which contain a huge amount of INSERT-Statements. When I build the project, the execution of the pdc-files takes too much time (around up to 10-20 minutes), which is inacceptable. The same scripts take only 1-2 minutes by a simple sqlplus call.
I guess PL/SQL Developer parses the whole script before executing and does not execute the statements one per line.
Has somebody any idea for a workaround?
Thanks in advance!
Greetings
sepp
I have a problem with a PL/SQL Developer project, where several pdc-files are called, which contain a huge amount of INSERT-Statements. When I build the project, the execution of the pdc-files takes too much time (around up to 10-20 minutes), which is inacceptable. The same scripts take only 1-2 minutes by a simple sqlplus call.
I guess PL/SQL Developer parses the whole script before executing and does not execute the statements one per line.
Has somebody any idea for a workaround?
Thanks in advance!
Greetings
sepp
