Re: how to use execute immediate with session killing?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Thu, 13 Feb 2003 18:35:21 GMT
Message-ID: <3e4be554.7424676@nyc.news.speakeasy.net>

execute immediate has some limitations
have you tried dbms_sql?

On 13 Feb 2003 10:21:22 -0800, rgaffuri_at_cox.net (Ryan Gaffuri) wrote:

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

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Thu Feb 13 2003 - 12:35:21 CST