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 -> possible to use alter system or alter session commands dynamically?

possible to use alter system or alter session commands dynamically?

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 14 Feb 2003 05:55:07 -0800
Message-ID: <1efdad5b.0302140555.7bb9a8db@posting.google.com> 





I asked this in another thread related to a specific task and got an
answer on how to do that task, which I appreciate.



However, I'm still wondering if its possible to do this? 



I tried:



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

     USING v_sid, v_serial#;



and it gave me some kind of parsing error. Is it functionally possible
to do this? Dont need to use it now. Just really curious. Its not in
the documentation.
Received on Fri Feb 14 2003 - 07:55:07 CST












Original text of this message













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