Re: SQLPLUS issue from ksh script
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: <david.barbour1@xxxxxxxxx>
- Date: Fri, 26 May 2006 20:30:30 +0200
It works in "pure" sqlplus, just not in the script.
Ideas? Thanks.
sqlplus "/ as sysdba" <<EOJ
declare
STR VARCHAR2(2000);
begin
for x in (select * from v\$session) loop
IF x.user# = 27 then
str := ' alter system kill session ''' || x.sid || ',' || x.serial#
||'''';
execute immediate str;
End if;
END LOOP;
end;
/
EOJ
Regards
Dimitre
--
//www.freelists.org/webpage/oracle-l
Other related posts: