Re: Killing user sessions within procedure

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 19 Mar 1999 14:39:40 -0000
Message-ID: <921854626.16301.0.nnrp-02.9e984b29@news.demon.co.uk>

There is a note (somewhere) that DDL will execute on the parse stage. The note also points out that this behaviour is not guaranteed. I infer that any code that fails to follow up with dbms_sql.execute will simply stop working one day when you upgrade the database.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

steve_mundie_at_my-dejanews.com wrote in message <7ct9se$j66$1_at_nnrp1.dejanews.com>...
>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?
Received on Fri Mar 19 1999 - 08:39:40 CST