Re: possible to use alter system or alter session commands dynamically?

i suggested this in the other thread as well. have you looked into dbms_sql?

On 14 Feb 2003 05:55:07 -0800, rgaffuri_at_cox.net (Ryan Gaffuri) wrote:

>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.

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Feb 14 2003 - 12:27:46 CST