help with a script

From: Ed Lufker <elufker_at_shimi.swcp.com>
Date: 20 Oct 2001 00:58:17 GMT
Message-ID: <9qqi79$8u6$1@sloth.swcp.com>

Hi All:

I have the following script, but it seems the $ sign in v$session is screwing me up, the scripts jumps to a new shell, and all is lost when that happens. How do I get around have a the $ sign in my script. The script follows

sqlplus -s system/manager << EOF
set head off
spool e.out
'select sid,serial#,process from v$session where status='SNIPED''; exit
EOF
sed -n -e '/^SQL/ !p' e.out > e2.out
while read a b c
do
svrmgrl << EOF
connect internal;
alter system kill session '$a, $b';
EOF
kill -9 $c
done < e2.out

Thanks for any help here
Eddie Lufker Received on Fri Oct 19 2001 - 19:58:17 CDT