批量执行sql脚本问题

zxy877298415

由于需要批量的执行sql脚本，这些*.sql的脚本都在一个目录下，使用如下的脚本，但是到了sqlplus下面就不行了，请问是怎么回事？
#!/bin/bash
ls -l > a.txt
a=`awk '{print $9}' a.txt`
for i in $a
do
sqlplus sales/sales
@$i
commit;
quit
done
echo "success!"

seesea2517

总感觉哪里写的不对，这sql的语句和shell语句混在一起了吧？

laliheyi

回复 1# zxy877298415

使用here document给sqlplus传递内容
   

Shell_HAT

1. #!/bin/bash
   
2. for i in `ls -l | awk '{print $9}'`; do
   
3. sqlplus sales/sales <<XXOO
   
4. @$i
   
5. commit;
   
6. quit
   
7. <<XXOO
   
8. done
   
9. echo "success!"

复制代码

q1208c

回复 4# Shell_HAT


      又见 XXOO. 兄弟, 注意身体.

expert1

明显要here doc

zxy877298415

谢谢，XXOO和各位大师！

zxy877298415

各位大师还得问一下，还是不行呢？
[oracle@tlgServer sinosoft]$ more sql.sh
#!/bin/bash

for i in `ls -l /home/sinosoft/sql | awk '{print $9}'`

do

sqlplus sales/sales <<XXOO

@$i

quit

XXOO

done

echo "success!


[oracle@tlgServer sinosoft]$ sh sql.sh

SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 25 16:57:20 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SQL> SP2-0310: unable to open file "a.sql"
SQL> SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 25 16:57:20 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SQL> SP2-0310: unable to open file "b.sql"
SQL> SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
success!

fantingftt123

执行的时候是不是需要加绝对路径。

zxy877298415

是的，就是少了绝对路径了.