When a user loads a large Insert statement file in SQL Editor i.e. a text file with 100,000 insert statements in it, then press F5 (Execute as Script), Toad will hang for about 3 minutes, and then an error "External Exception E06D7363" occurs.
If a user chooses "Execute in SQL Plus" or "Execute in QSR" and execute the whole 100,000 insert statements, it works fine.
Use "Execute in SQL Plus" or "Execute in QSR" to run the insert statements.
Toad developers mentioned that this is not a Bug in Toad, but rather just the wrong Toad functionality to use for running large amounts of insert statements. This is also why Toad has the "Execute in SQL Plus" and "Execute in QSR" feature which can better handle large amounts of insert statements.
