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

On Sun, 20 Feb 2000 10:29:05 +0000, Leonard Will <L.Will_at_Willpower.demon.co.uk> wrote:

>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/> ----------------
 SQL*Plus is single threaded on Windows 95/98. You need to connect from a second instance of SQL*Plus, identify your session from V$Session and alter the session to disconnect it (I don't have the exact syntax right now)

Brad Received on Sun Feb 20 2000 - 15:39:11 CST