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).
