SQL*Plus (MOSC)

MOSC Banner

How to stop script files without dropping out of SQL*Plus?

edited Jul 25, 2019 11:30AM in SQL*Plus (MOSC) 9 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center