Errors with select * from v$session
From: M. ARNAMI <m.arnami_at_skynet.be>
Date: Mon, 5 Jul 1999 12:07:01 +0200
Message-ID: <7lq0ar$gde$1_at_calais.pt.lu>
Hello,
Does anyone know how to select from v$session in oracle procedure script ! I work with Personal Oracle7.3.4 on Win95
isLocked boolean := false ;
curr_stat char(1) ;
by_user_id char(8) ;
in_poste char(10) ;
c BINARY_INTEGER := 0;
13/29 PLS-00201: identifier 'SYS.V_$SESSION' must be declared 13/1 PL/SQL: SQL Statement ignored Received on Mon Jul 05 1999 - 12:07:01 CEST
Date: Mon, 5 Jul 1999 12:07:01 +0200
Message-ID: <7lq0ar$gde$1_at_calais.pt.lu>
Hello,
Does anyone know how to select from v$session in oracle procedure script ! I work with Personal Oracle7.3.4 on Win95
The portion of script is :
Create or replace procedure get_unite(unite_id_in IN OUT char , user_id_in IN OUT char) is
isLocked boolean := false ;
curr_stat char(1) ;
by_user_id char(8) ;
in_poste char(10) ;
c BINARY_INTEGER := 0;
begin
select statut, user_id, poste into curr_stat, by_user_id, in_poste
from UNITE where unite_id=unite_id_in FOR UPDATE ;
if curr_stat = '1' then
select count(*) into c from v$session
where rtrim(client_info) =
rtrim(by_user_id)||rtrim(in_poste);
if c > 0 then isLocked := true ; end if;
end if ;
........
end get_unite;
/
I have error following error after compilation with no system user:
Errors for PROCEDURE GET_UNITE:
13/29 PLS-00201: identifier 'SYS.V_$SESSION' must be declared 13/1 PL/SQL: SQL Statement ignored Received on Mon Jul 05 1999 - 12:07:01 CEST