| session kill [message #308211] |
Sat, 22 March 2008 02:12  |
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 #308270 is a reply to message #308269] |
Sun, 23 March 2008 02:41  |
 |
Michel Cadot
Messages: 68745
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
