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