11g sqlplus (command line)
15671Apr 17 2009 — edited Oct 12 2012Hello -
I just have this basic question to all of you , who are using 11g sql+ client.
I have sqlplus client installed on my windows box, which created a shortcut to this executable (.....11.1.0\client_1\BIN\sqlplus.exe)
when I invoke it, it opens a command line & lands straight into SQL..
The problem I am facing is..mainly with PLSQL..since I have gotten so much used to SQLPLUS GUI..I am used to CTRL+C whenever I want to break out of PLSQL code I am typing..
but starting 11g..onwards it terminates the entire shell & quits
if its sqlplus.exe - it closes the entire window
if I invoke manually from command prompt, I get kicked out of sql shell
SQLPLUS GUI (10.2)
-------------------------------------
SQL> set serveroutput on
SQL> begin
2 dbms_output.put_line('****');
3 end;
4 /
****
PL/SQL procedure successfully completed.
SQL> begin
2 dbms_output.put_line('*****');
3 -- pressing CTRL+C now
SQL> <-- I am back to SQL..so now I can edit and change whatever the last code and rerun
****************
SQLPLUS 11g - command line mode
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Apr 17 14:51:33 2009
SQL> begin
2 dbms_output.put_line('***');
3 end;
4 /
***
PL/SQL procedure successfully completed.
SQL> begin
2 dbms_output.put_line('***');
3 -- Pressing CTRL+C now
4 Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:\orcl\product\11.1.0\client_1\BIN> <--- I lost my session?????
---------------
worse if I invoke SQLPLUS.exe from shortcut.. the entire window disappears
anyone knows how to disable CTRL+C or alternative key combination that would work in 11g client?
Thanks in advance