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 -> Re: DISCONNECT ALL FROM A COMMAND IN PROCEDURE !!!!!!!

Re: DISCONNECT ALL FROM A COMMAND IN PROCEDURE !!!!!!!

From: victor <victor_at_PERCOMBANK.KIEV.UA>
Date: 10 Nov 1998 12:38:25 GMT
Message-ID: <01be0ca6$f17d7cb0$6b14abcc@victor>


from sql plus you can write like this
alter system kill session 'cid,cerial'
(select it from v$session)

in pl/sql proc you can do this with use dbms_sql package Received on Tue Nov 10 1998 - 06:38:25 CST

Original text of this message

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