Re: Killing user sessions within procedure

I haven't done it personally but i do have a reference to a paper called 'Kiling an Oracle Session' via the Revealner home page. Try www.revealnet.com/orashut.htm It references some of the stuff you mentioned (dbms_sql.parse etc)

Mark

steve_mundie_at_my-dejanews.com wrote in message <7ct9se$j66$1_at_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 - 06:22:06 CST