Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> how to use execute immediate with session killing?

how to use execute immediate with session killing?

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 13 Feb 2003 10:21:22 -0800
Message-ID: <1efdad5b.0302131021.3bef58bb@posting.google.com> 





this is dying on me. is there a way to do this dynamically?



  EXECUTE IMMEDIATE 'ALTER SYSTEM KILL SESSION '':1,:2''';

    USING v_sid, v_serial#;



I have a requirement to allow users to be able to kill a job that is
running. only way to do that is to kill the session. So Im giving them
a wrapper.
Received on Thu Feb 13 2003 - 12:21:22 CST












Original text of this message













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