Home » Developer & Programmer » Forms » How to execute ALTER SYSTEM command from Developer (Developer, 6i, Xp)
How to execute ALTER SYSTEM command from Developer [message #296843] Tue, 29 January 2008 04:31 Go to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Hi,

I have form that is for only users with ADMIN previleges. That form need to issue ALTER SYSTEM command like kill session.

When I try to complie my form with ALTER SYSTEM KILL SESSION command it didn't recognize this command and give me error.

I an execute this statement through a database trigger but Is there any other way to do this.
Re: How to execute ALTER SYSTEM command from Developer [message #296857 is a reply to message #296843] Tue, 29 January 2008 06:10 Go to previous messageGo to next message
sasipalarivattom
Messages: 118
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member

Hi there..
I have done such a form and i use forms_ddl for that.
the sql statement i use is

  forms_ddl('alter system kill session '||chr(39)
  ||:SID||','||:SERIAL#||chr(39));


Hopes this will satisfy you..

Regards
Sasi..
Re: How to execute ALTER SYSTEM command from Developer [message #297013 is a reply to message #296857] Tue, 29 January 2008 22:41 Go to previous message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Thanks
Previous Topic: looking field after leaving the field
Next Topic: addition of column
Goto Forum:
  


Current Time: Fri Dec 09 17:19:02 CST 2016

Total time taken to generate the page: 0.33825 seconds