Script execution ends prematurely without any error message in Toad for Oracle
説明
Long and nested SQL scripts are not executed completely. The execution stops somewhere in the middle without any error message.
原因
Defect ID - TOR-6377
Memory usage increases as script executes. Script execution stops somewhere in the 6th or 7th outer loop. Closing Editor after running script does not make memory usage drop down to normal.
対策
WORKAROUND
Use SQL Plus to execute the script
STATUS
Waiting for fix in a future release of Toad for Oracle.