how do i insert a shell var into sqlplus ?

[ebrian]

You could do something like:

#!/usr/bin/ksh
v_dir=/tmp
sqlplus -s scott/tiger @${v_dir}/test.sql