OraFAQ Forum: Forms » How to execute ALTER SYSTEM command from Developer

Home » Developer & Programmer » Forms » How to execute ALTER SYSTEM command from Developer (Developer, 6i, Xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to execute ALTER SYSTEM command from Developer [message #296843]

Tue, 29 January 2008 04:31

azamkhan
Messages: 557
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.

Report message to a moderator

Re: How to execute ALTER SYSTEM command from Developer [message #296857 is a reply to message #296843]

Tue, 29 January 2008 06:10

sasipalarivattom
Messages: 121
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..

Report message to a moderator

Re: How to execute ALTER SYSTEM command from Developer [message #297013 is a reply to message #296857]

Tue, 29 January 2008 22:41

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Thanks

Report message to a moderator

Previous Topic:	looking field after leaving the field
Next Topic:	addition of column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 25 08:50:10 CST 2025