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

From: Ryan <rgaffuri_at_cox.net>
Date: Fri, 14 Feb 2003 20:51:03 GMT
Message-ID: <XEc3a.8096$4F3.410118@news2.east.cox.net>

"NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message news:3e4d3513.93375426_at_nyc.news.speakeasy.net...
> 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

yeah I avoid DBMS_SQL like the plague. Probably a bad idea... Received on Fri Feb 14 2003 - 14:51:03 CST