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:JBECKSTROM_at_gcrta.org]
>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: hkchital_at_singnet.com.sg

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: ListGuru_at_fatcity.com (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).