Re: Forms 4.5

levy.lee.ls_at_bhp.com.au (Lee levy) wrote:

> In article <4b6te5$1fp_at_news.corpcomm.net>, kasten_at_brookings.net (Chris Kasten) says:
> >
> >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!
> >

> Try putting the 'alter' call inside a Forms_DDL invocation.
> It works for alter user.
> Might be worth a try for the explain plan, too.

Thanks Lee, I'll have to look into that. I had just found one solution - used the DBMS_SQL package. That seems to work. I don't believe I was aware that there is a Forms_DDL - is it documented anywhere?

Thanks again,

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

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