How to stop script files without dropping out of SQL*Plus?
Hi all
Since Oracle 11.1 there is no more specific Windows version (sqlplusw.exe). When I press Ctrl-C within the remaining sqlplus.exe during a running command it stops perfectly and I can continue with my work.
But when I would like to abort a SELECT-outputlist on a page-pause or a script file while it's waiting on an ACCEPT- or PAUSE-command, I found no solution: Pressing Ctrl-C not only ends the script file or select-command as in sqlplusw.exe, it closes the whole SQL*Plus!
Which could be very dangerous, because of maybe already done but not commited DMLs which will be autocommited or rollbacked. And it's boring too to restart the whole work up to this point.
Since Oracle 11.1 there is no more specific Windows version (sqlplusw.exe). When I press Ctrl-C within the remaining sqlplus.exe during a running command it stops perfectly and I can continue with my work.
But when I would like to abort a SELECT-outputlist on a page-pause or a script file while it's waiting on an ACCEPT- or PAUSE-command, I found no solution: Pressing Ctrl-C not only ends the script file or select-command as in sqlplusw.exe, it closes the whole SQL*Plus!
Which could be very dangerous, because of maybe already done but not commited DMLs which will be autocommited or rollbacked. And it's boring too to restart the whole work up to this point.
2