While循环里不能工嵌套SQL语句吗???

leoxhj

各位大虾请帮我看一下错在哪里???
源码:
while read get_cellphone_number
do
  while read get_date
  do
    sqlplus cbqr/zm01cbqr@zjcb1 <<EOF   
    spool ${my_dir}/data/bill_result.txt;
    select vplmn2,start_time,duration,user_number,opp_user_number,msc_id,lac_id,cell_id  from aicbs.dr_gsm_hz_${get_date} where user_number='${get_number}'  order by start_time;
    spool off;
    exit;
    EOF
  done <get_date.txt
done <bill.txt

出错信息:
police.sh[21]: Syntax error at line 25 : `<<' is not matched.

欧阳不修

try:
cat > tmp.sql <<EOF
spool ${my_dir}/data/bill_result.txt
select vplmn2,start_time,duration,user_number,opp_user_number,msc_id,lac_id,cell_id from aicbs.dr_gsm_hz_${get_date} where user_number='${get_number}' order by start_time;
spool off
exit
EOF
sqlplus cbqr/zm01cbqr@zjcb1 @tmp.sql
rm tmp.sql

leoxhj

不行

欧阳不修

where user_number='${get_number}'
这儿有问题，你改成动态ｓｑｌ写你的ｓｅｌｅｃｔ语句把

leoxhj

已经自己搞定，以下为解决的新方法：
while read get_cellphone_number
do
while read get_date
do
   do_sql.sh  $get_date $get_cellphone_number
done <get_date.txt
done <bill.txt

以下为do_sql.sh 内容
sqlplus cbqr/zm01cbqr@zjcb1 <<EOF
spool ${my_dir}/data/bill_result.txt;
select vplmn2,start_time,duration,user_number,opp_user_number,msc_id,lac_id,cell_id from ${1} where user_number='${2}' order by start_time;
spool off;
exit;
EOF

wangnb

我是新手，请问上面的代码是什么意思？
是用SQL读TXT文本文件吗？
能否祥解一下。。。

欧阳不修

sqlplus username/pw@servicename <<!
sql语句；
!

指sqlplus连接数据库执行!之间的sql语句，其中!可以用别的字符或串替代