Re: Forms 4.5

Solved(?)

Combinations of Forms_DDL and DBMS_SQL
procedures appear to be able to solve all of my problems.

Thanks to everybody for their advice

kasten_at_brookings.net (Chris Kasten) wrote:

> I am consolidating many of my SQL scripts into a
> single form. Most are pretty easy, but am having
> some difficulties. For instance, suppose one
> has selected a session from a sessions block
> and wishes to kill it. Getting the SID and SERIAL#
> is easy enough, but how the _heck_ does one
> execute the statement
> Alter system kill session ':sid, :serial#' ?
 

> Would prefer to accomplish this from
> within the form as opposed to hosting out
> to SQL*Plus - is it possible? If so, how about
> a real challenge - Explain Plan!
 

> Thanks in Advance,
 

> Chris Kasten
 

> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Chris Kasten
> Programmer/Analyst (among others...)
 

> #include <sys/std_disclaimer.h>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Chris Kasten
Programmer/Analyst (among others...)

#include <sys/std_disclaimer.h>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Received on Thu Dec 21 1995 - 00:00:00 CET