每当我使用sql * plus运行sql脚本并检查$?,即使脚本不成功,也会得到0.
原文链接:https://www.f2er.com/oracle/205457.html例
#$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 $
我希望在发生错误时返回非零值.
我该如何实现呢?