Re: ctrl c on PCs
try ctrl-y on VMS, it interrupts the session. [EMAIL PROTECTED] 09/06/02 09:58AM In sql*plus, if do a ctrl-c from within sqlplus I am returned to the dos prompt. However, from OpenVMS, I am kept in sql*plus. We have some scripts that do a pause in them so can terminate if a problem. However, if hit ctrl-c during the pause sql*plus ends commiting the updates. Shouldn't sql*plus just return to a prompt or is this normal on windows. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ctrl c on PCs
Jeffrey In the first case you are executing SQL*Plus directly on your PC. In the OpenVMS case, I assume that you are using some terminal emulation program to reach OpenVMS and starting SQL*Plus on that system. You may want to verify whether your terminal emulation program is sending the control-C. I regularly use a terminal emulation program that doesn't send the control-C along, and this is irritating. To kill something I just start another window and kill the other session from there. There may be a setting somewhere you can change if this is the situation. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 06, 2002 8:58 AM To: Multiple recipients of list ORACLE-L In sql*plus, if do a ctrl-c from within sqlplus I am returned to the dos prompt. However, from OpenVMS, I am kept in sql*plus. We have some scripts that do a pause in them so can terminate if a problem. However, if hit ctrl-c during the pause sql*plus ends commiting the updates. Shouldn't sql*plus just return to a prompt or is this normal on windows. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ctrl c on PCs
Be careful about setting AutoCommit. What if you really want to abort a transaction in certain cases ? Hemant At 06:43 AM 06-09-02 -0800, you wrote: Set autocommit to on and try. that will commit before exiting sqllplus Shiva -Original Message- From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Subject: ctrl c on PCs In sql*plus, if do a ctrl-c from within sqlplus I am returned to the dos prompt. However, from OpenVMS, I am kept in sql*plus. We have some scripts that do a pause in them so can terminate if a problem. However, if hit ctrl-c during the pause sql*plus ends commiting the updates. Shouldn't sql*plus just return to a prompt or is this normal on windows. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).