Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

11g sqlplus (command line)

15671Apr 17 2009 — edited Oct 12 2012
Hello -
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2012
Added on Apr 17 2009
12 comments
10,949 views