每当我使用 Sql*plus 运行 sql 脚本并检查 $? 时,即使脚本不成功,我也会得到 0。
Example
#$ 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
$
我希望它在发生错误时返回一个非零值。
我怎样才能做到这一点?
你必须明确告诉sqlplus
在你的脚本中做到这一点。基本上,您可以使用两种语句:
WHENEVER SQLERROR EXIT SQL.SQLCODE
WHENEVER OSERROR EXIT
例如:
WHENEVER SQLERROR EXIT SQL.SQLCODE
begin
SELECT COLUMN_DOES_NOT_EXIST FROM DUAL;
END;
/
对于操作系统错误:
WHENEVER OSERROR EXIT FAILURE
START no_such_file
有关更多信息,请参阅this http://docs.oracle.com/cd/B19306_01/server.102/b14357/ch12052.htm and that http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve051.htm.
希望能帮助到你。祝你好运!
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)