Re: Active Sessions
From: Geoffrey <g.dufour_at_swing.be>
Date: Wed, 23 Jan 2002 10:30:49 +0100
Message-ID: <3c4e81ca$0$33513$ba620e4c_at_news.skynet.be>
Date: Wed, 23 Jan 2002 10:30:49 +0100
Message-ID: <3c4e81ca$0$33513$ba620e4c_at_news.skynet.be>
Thanks a lot for your help !
Can you tell me why this script does not work ?
(I have the right system privileges)
CREATE OR REPLACE PROCEDURE test IS
thesid NUMBER := 0;
BEGIN Select sid into thesid from v$session where program = 'blablabla' and status != 'KILLED'; END test;
/
quit;
Regards. Received on Wed Jan 23 2002 - 10:30:49 CET