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

Home -> Community -> Usenet -> c.d.o.misc -> 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: Mon, 14 Feb 2000 12:16:52 +0000
Message-ID: <5csscHA0I$p4EwnF@willpower.demon.co.uk>


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

At present I am forced to cancel the task by using CTRL-ALT-DEL 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?

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 Mon Feb 14 2000 - 06:16:52 CST

Original text of this message

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