Thanks for your kindly reply. I have disabled 'Add debug information when compiling' option, but the issue remains. And I also compile all packages in the Toad. But in PL/SQL Develper, the issues remains. Because our develpers don't like to abandon this tool, we still hope to solve the problem...
I just click the button 'execute' (highlight by red line) after editing the large package spec & body, the PL/SQL Developer will have no responding. But the small packages are ok.
I am sure that there are no other sessions locking on the package I am trying to execute in PL/SQL Developer. I executed the script checking for locks, but no rows selected.
Hi, guys! We have some PL/SQL packages that have more then 2000 lines codes. When these packages are executed in PL/SQL Developer, the Developer will be no responding. But the small packages which have less then 1500 lines codes can be executed successfully and quickly. And all packages locating...