- 论坛徽章:
- 0
|
本帖最后由 horse285 于 2013-10-18 16:33 编辑
当执行如下脚本时;
#!/bin/bash
trap "echo ctrl c" INT
LOCAL_DB="aa/$USER"
LOCAL_SQL=" select distinct status from tb"
CONNECT_SQL()
{
sqlplus -S $1 <<EOF
$2
quit;
EOF
}
main()
{
trap "echo ctrl c" INT
while true
do
echo -------------------------------------
ZC=`CONNECT_SQL "$LOCAL_DB" "$LOCAL_SQL"`;
sleep 1
echo "$ZC"
done
}
main
如果正好在执行sql语句,同时按了ctrl+c. sql语句就被打断了. 同时报了如下的错误:
select distinct status from tb
*
ERROR at line 1
想请教的是:如何不让sql语句执行不被打断?
或则sqlpluse 里有什么设置可以忽略信号? |
|