SQL*Plus (MOSC)

MOSC Banner

Quickly abort initial sqlplus connection in 18.2

edited Mar 2, 2019 4:01AM in SQL*Plus (MOSC) 4 commentsAnswered

Previously, pressing Control-C in sqlpus almost always exits sqlplus, and occasionally stops a long running SQL. Sqlplus 18.2 has solved the problem nicely (probably related to Bug 20444821). Pressing Control-C aborts a long-running SQL and returns the cursor to the SQL> prompt, or if there's no SQL running, Control-C behaves like pressing Return twice. If you're used to pressing ^C to abort and exit Sqlplus, now you type exit or quit.

On the other hand, suppose you give a wrong connect identifier, sqlplus myusername@nosuchdb takes quite a while to try connecting, and aborts after (probably) some type of Windows network timeout. Previously, Control-C would immediately abort this connection attempt. Now we have to wait, or use Task Manager to kill the sqlplus.exe process, because Control-C is captured and re-interpreted. Is there a better or faster way to abort this connection going nowhere?

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