Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to interrupt or cancel an SQL process in Personal Oracle 7.3.4?
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