Killing user sessions within procedure

From: <steve_mundie_at_my-dejanews.com>
Date: Fri, 19 Mar 1999 10:45:35 GMT
Message-ID: <7ct9se$j66$1@nnrp1.dejanews.com>

I'm trying to remove (programatically) all users of an instance without shutting it down.

Using a script to write a script then executing that script is possible but I'd like to have as little ineraction with the operating system as possible.

I have a procedure which builds up "alter system kill session 'a,b' " strings then uses dbms_sql.parse() to execute it but I can't kill sessions with it. Similar code does drop tables successfully.

Has anyone done this or is it only DDL you can run using the dbms_sql.parse() technique?

SteveM

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 19 1999 - 04:45:35 CST