SQL * Plus总是返回退出代码0? [英] Sql*plus always returns exit code 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
• WHENEVER OSERROR EXIT

• 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

有关更多信息，请参见此和

For more information, see this and that.

希望它会有所帮助.祝你好运！

Hope it helps. Good Luck!

这篇关于SQL * Plus总是返回退出代码0?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！