When using a script to create another script file, 9.6 hangs/crashes unexpectedly at the line 'PROMPT COMMIT;;'.
This command is used to write 'COMMIT;' in another file.
The script works with Toad 9.1, but doesn't in 9.6
Sample:
SET LINESIZE 2000 NEWPAGE 0 PAGES 0 RECSEP OFF PAUSE OFF;
SET FEEDBACK OFF;
SET TRIMSPOOL ON;
SET ECHO OFF;
SET TERM OFF;
SET DEFINE ON;
SET VERIFY OFF;
SPOOL C:\test_folder\est_script.sql;
--
PROMPT
PROMPT
PROMPT PROMPT
PROMPT PROMPT '<some script here>'
PROMPT PROMPT
PROMPT
PROMPT COMMIT/
PROMPT
-- comment/un comment the 3 lines below to test in 9.6
--PROMPT
--PROMPT COMMIT;;
--PROMPT
SPOOL OFF;
SET TERM ON;
PROMPT
PROMPT
With the line commented out, the .SQL file created shows:
PROMPT
PROMPT '<some script here>'
PROMPT
COMMIT/
Without the line commented out, in Toad 9.6, the application hangs.
Changes in the formatter in the new 9.6 checks for unhandled syntax like COMMIT;;
Please upgrade to Toad 9.7 for better handling of the unknown command.
Toad 9.7 does not hang. But keep in mind the syntax is still not correct, and the new formatter will still specify there is an issue by writing into the newly created .SQL.
Without the line commented out, in Toad 9.7, the application will create a .SQL file like:
PROMPT
PROMPT '<some script here>'
PROMPT
COMMIT/
COMMIT
unknown command "sqlplus" - rest of line ignored.
Please check Toad's help file for further info about specific SQL*Plus Commands.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center