Re: Cancelling a running Server task from a Client

Hi Thomas,

try "select * from v$session;" and then "alter system kill session <SID>,<SERIAL#>;"

In an application you can use the dbms_sql-Package.

Martin

>
> SQL*Plus v3.3 provides a Cancel facility to enable a user running
> SQL*Plus as a client to Cancel a already running Server request. Does
> anybody know how it does this as we have searched the documentation
> with no result. We need to emulate the Cancel functionality in an
> online application we are building.
>
> We are running an online COBOL CICS application on an IBM MVS system.
> We want to handle the situation where the user just switches their
> terminal off. Within the CICS application we can detect the switchoff
> but we can't clean up the Oracle server request that is already
> running as we don't know how to Cancel it from within CICS. (The CICS
> application appears as a client to Oracle).
>
> Any help would be gratefully received.
>
> --
> Paul Thomas
> NCM Credit Insurance,
> Cardiff, Wales
> http://www.ncmgroup.com/
> http://www.pumphouse.demon.co.uk/

--
C+C Schaper GmbH
Eckener Str. 2
D-30179 Hannover