oracle执行plus时跳出,oracle – 从shell脚本运行sqlplus时管理错误处理

马克斯说的是正确的.尝试这个修改的脚本

#!/bin/sh

echo "Please enter evaluate database username"

read eval_user

echo "Please enter evaluate database password"

read eval_pass

echo "Please enter the database name"

read db_name

LOGFILE=shell_log.txt

sqlplus -s /nolog <> ${LOGFILE}

WHENEVER OSERROR EXIT 9;

WHENEVER SQLERROR EXIT SQL.SQLCODE;

connect $eval_user/$eval_pass@$db_name

DBMS_OUTPUT.put_line('Connected to db');

EOF

sql_return_code=$?

if [ $sql_return_code != 0 ]

then

echo "The upgrade script failed. Please refer to the log results.txt for more information"

echo "Error code $sql_return_code"

exit 0;

fi

请注意使用sql_return_code来捕获SQLPLUS返回码.

DBMS_OUTPUT语句应该失败,并出现错误 – “SP2-0734：unknown命令开始…”.您可以在日志文件中找到错误消息.