Sql*plus 总是返回退出代码 0?
每当我使用 Sql*plus 运行 sql 脚本并检查 $? 时，即使脚本不成功，我也会得到 0.
Whenever I run a sql script using Sql*plus and check for $?, I get 0 even when the script wasn't succesful.
示例
#$ sqlplus user/password@instance @script.sql
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 7 14:20:44 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
v$dataf-ile d,
*
ERROR at line 6:
ORA-00933: SQL command not properly ended
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
$ echo $?
0
$
我希望它在发生错误时返回一个非零值.
I would like it to return a non-zero value when an error occurs.
我怎样才能做到这一点?
推荐答案
您必须在脚本中明确告诉 sqlplus 这样做.基本上，您可以使用两个语句:
You have to explicitly tell sqlplus to do that, in your script. Basically, there are two statements that you can use:
WHENEVER SQLERROR EXIT SQL.SQLCODE当 OSERROR 退出时
例如:
WHENEVER SQLERROR EXIT SQL.SQLCODE
begin
SELECT COLUMN_DOES_NOT_EXIST FROM DUAL;
END;
/
对于操作系统错误:
WHENEVER OSERROR EXIT FAILURE
START no_such_file
有关详细信息，请参阅此和那个.
For more information, see this and that.
希望有帮助.祝你好运！
Hope it helps. Good Luck!
相关文章