Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00026: missing or invalid session ID

malhiSep 27 2010 — edited Sep 27 2010
I am receiving following error, while executing a procedure kill_session

EXEC kill_session('USERNAME');

4329 267 TARIQ_CORE
ORA-00026: missing or invalid session ID
create or replace
procedure kill_session (usr_2_kill in varchar2)

as

vsid    number(6);
vserial number(6);

 begin

  for s_info in (select * from v$session where username=usr_2_kill) 
  
  loop
     vsid    := s_info.sid;
     vserial := s_info.serial#;

     dbms_output.put_line(vsid||'  '||vserial||'  '||usr_2_kill);
     
     execute immediate 'alter system kill session(:v1,:v2) immediate' using vsid,vserial;
          
  end loop;
   EXCEPTION
      WHEN OTHERS
      THEN
         dbms_output.put_line(SQLERRM);
   END; 
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2010
Added on Sep 27 2010
9 comments
14,896 views