unix/sqlplus host variables

I would like to get in a unix variable the result of a query in a ksh script.

The ksh script i wrote is like (which doesn't work)

#! /bin/ksh
sqlplus $user/$password << EOF
select count(*) into :nRes from Table
EOF
echo $nRes

I didn't find any way to get the result of my query without using a temporary file or the instruction : var=`sqlplus ...`

is there any way to return a sqlplus result in a unix variable ?

Thanks for any answer !! Received on Wed Nov 07 2001 - 12:43:32 CST