sqlplus连接字符串问题
我有一个SQL连接字符串,看起来
echo $SQLSTR
sys/<pwd>@(DESCRIPTION=(ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME=xxxx)(INSTANCE_NAME=xxxx))) AS SYSDBA"
我能够连接通过
sqlplus -s /nolog << EOF
WHENEVER SQLERROR EXIT 99
connect ${SQLSTR}
EOF
我无法成功将连接放在文件之外。我尝试了2个选项,但他们不为我工作。想为解决此问题提供一些帮助
sqlplus "${SQLSTR}" > $log << EOF
WHENEVER SQLERROR EXIT ROLLBACK
....
EOF
SQLSTR2="\"$SQLSTR\""
sqlplus "${SQLSTR2}" > $log << EOF
WHENEVER SQLERROR EXIT ROLLBACK
....
EOF
I have a sql connection string that looks like
echo $SQLSTR
sys/<pwd>@(DESCRIPTION=(ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME=xxxx)(INSTANCE_NAME=xxxx))) AS SYSDBA"
I was able to connect through
sqlplus -s /nolog << EOF
WHENEVER SQLERROR EXIT 99
connect ${SQLSTR}
EOF
I could not succeed in putting the connection outside the file. I have tried with 2 options, and they are not working for me. Wanted to get some help fixing this
sqlplus "${SQLSTR}" > $log << EOF
WHENEVER SQLERROR EXIT ROLLBACK
....
EOF
SQLSTR2="\"$SQLSTR\""
sqlplus "${SQLSTR2}" > $log << EOF
WHENEVER SQLERROR EXIT ROLLBACK
....
EOF
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论