Hi,
I have a short script that shows the number of connection to our database,
for some reason it dosn't read the whole line. It drop the v$session to just
'v' any ideas as to what is wrong?
Unix Tru64 Version 5.0a (Version M-11/16/88)
#!/bin/ksh
set -vx
ORACLE_SID=CUST export ORACLE_SID
value=`sqlplus "system/manager" <<END
select USERNAME, OSUSER from v$session;
exit;
END`
if [ -z "$VALUE" ]; then
echo "NO rows returned from database!"
exit 0
else
echo $VALUE
fi
Regards
Mark
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
Received on Wed Jun 06 2001 - 10:07:22 NZST