Re: Forms 4.5

From: Lee levy <levy.lee.ls_at_bhp.com.au>
Date: 1995/12/20
Message-ID: <4ba80q$daq_at_gossamer.itmel.bhp.com.au>#1/1

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!
>
>Thanks in Advance,
>
>Chris Kasten
>
>-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>Chris Kasten
>Programmer/Analyst (among others...)
>
>#include <sys/std_disclaimer.h>
>-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>

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.

Lee

---

      /\/\      :  Lee Levy, ISSD Systems Development
     / / /\     :  BHP Information Technology (WOLLONGONG REGION)
    / / /  \    :  PO Box 261, Warrawong, NSW 2502, Australia
   / / / /\ \   :  ACN 006 476 213
   \ \/ / / /   :  Telephone:  +61 42 75-5485  (tie-line 8855-)
    \  / / /    :  Facsimile:  +61 42 75-5500
     \/\/\/     :  Internet :  levy.lee.ls_at_bhp.com.au
====================================================================

Opinions expressed are my own and not necessarily those of either my employer or their clients Received on Wed Dec 20 1995 - 00:00:00 CET