We have a build script for our schema with hundreds of call to scripts, which we run using "Execute as Script"
The build script is typically like this..
Each of those scripts can themselves call other scripts / compile objects etc. Sometimes we have to run the build script multiple times if an error occurred during a run - we fix and re-run.
A recurring issue we see whilst running is TOAD erring with API Guard error....!Function 5308 (QP5_CHK GET_FIRST_MESSAGE) was called with a NULL handle, like this... TOAD_Error|389x176 and we always have to shut down TOAD as it becomes unstable, like starts giving syntax errors, where there is no syntax error. It occurs a lot.