shell 与sqlplus 交互传参数

#!/bin/ksh

#获取数据库参数表参数

proc_path=`sqlplus -silent "usename/password@consid" <<END
set pagesize 0 feedback off verify off heading off echo off;
select m_kind from table_name where tt<='$0';
exit;
END`
if [ -z "$proc_path" ]; then
echo "empty"
exit 0
else
echo $proc_path
fi