I’m executing a long-running SP - around 15-20 minutes - in Toad. I wrote a script with
Nothing is executed after the SP.
When Toad was processing the script, Script Output window showed ‘PL/SQL Procedure successfully completed’ after around 17 minutes of execution. But the ‘Processing script’ window did not stop running even after that. It kept going for an additional 7 minutes before it finally closed and main Toad window became active. I checked the end time printed inside my SP and sure enough, it had run under 17 minutes. Any ideas on the reasons why the ‘Processing Script’ keeps running even after the final statement of the script completes?
This is impacting my testing time