Home » Developer & Programmer » Forms » session kill
session kill [message #308211] Sat, 22 March 2008 02:12 Go to next message
roni_a180
Messages: 45
Registered: October 2007
Member
hello

every time i login database user, (only normal user not a database user)

when i login first time i kill session (which session i kill , i close my session but session is not closed properly)


my code is

for c1rec in (select sid as sid,serial# as serial from v$session
where username = :username)

loop

v_sid := c1rec.sid;
v_serial := c1rec.serial;

v_statement := 'ALTER SYSTEM KILL SESSION ' ||''''||v_sid||','||v_serial||''''||' IMMEDIATE';

forms_ddl(v_statement);
--forms_ddl('COMMIT');
end loop;

forms_ddl('commit');
end;



it's urgent
pls help
ok
thanx
Re: session kill [message #308214 is a reply to message #308211] Sat, 22 March 2008 02:40 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Your code
v_statement := 'ALTER SYSTEM KILL SESSION ' ||''''||v_sid||','||v_serial||''''||' IMMEDIATE';


Correct Code
v_statement := 'ALTER SYSTEM KILL SESSION '||''''||NAME_IN(v_sid)||','||v_serial)||'''';

Regards,
Azam Khan
Re: session kill [message #308269 is a reply to message #308211] Sun, 23 March 2008 02:35 Go to previous messageGo to next message
roni_a180
Messages: 45
Registered: October 2007
Member
hello

thanx to u'r reply

it is a database user but not in dba user;

only select permission .

it's is not working

ok
Re: session kill [message #308270 is a reply to message #308269] Sun, 23 March 2008 02:41 Go to previous message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't have the privilege to do this then you don't have the privielege to do this.
Nothing will work.
You should ask yourself if you don't need to change your application to correctly disconnect.

Regards
Michel
Previous Topic: Problem in duplicate record
Next Topic: Forms stopped running suddenly
Goto Forum:
  


Current Time: Mon Dec 05 11:14:47 CST 2016

Total time taken to generate the page: 0.10100 seconds