Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to interrupt or cancel an SQL process in Personal Oracle 7.3.4?

How to interrupt or cancel an SQL process in Personal Oracle 7.3.4?

From: Leonard Will <L.Will_at_Willpower.demon.co.uk>
Date: Sun, 20 Feb 2000 10:29:05 +0000
Message-ID: <2PffoHAxH8r4Ewm3@willpower.demon.co.uk>


I sent this message to comp.databases.oracle.misc about a week ago but it has produced no response there. I am therefore sending it to comp.databases.oracle.server in case that group is more appropriate.

According to the documentation in 'SQL*Plus Getting Started for Windows Platforms' it should be possible to interrupt an SQL operation (such as a long-running SELECT or UPDATE) by using CTRL+C or by using the "Cancel" option on the "File" menu.

Neither of these works for me: CTRL+C does nothing, and the drop- down menus don't drop down while an operation is in process. Is this normal or should I look for a problem with my installation? I am running Personal Oracle 7.3.4 on a stand-alone PC with no network connections, using Windows95. (I cannot use a later version because I have to stay compatible with a client's system.)

At present I am forced to cancel the task by using CTRL-ALT-DEL and/or to stop the Oracle database? Is there a risk of corruption in using either of these, or can I rely on Oracle rolling back the interrupted transaction in all cases? I have already found that Oracle doesn't rollback the incrementation of numbering sequences.

Leonard Will

--

Willpower Information        (Partners: Dr Leonard D Will, Sheena E Will)
Information Management Consultants               Tel: +44 (0)20 8372 0092
27 Calshot Way, Enfield, Middlesex EN2 7BQ, UK.  Fax: +44 (0)20 8372 0094
L.Will_at_Willpower.demon.co.uk            Sheena.Will_at_Willpower.demon.co.uk
---------------- <URL:http://www.willpower.demon.co.uk/> ----------------
Received on Sun Feb 20 2000 - 04:29:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US