Sql*plus always returns exit code 0?

by

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

For example:

WHENEVER SQLERROR EXIT SQL.SQLCODE
begin
  SELECT COLUMN_DOES_NOT_EXIST FROM DUAL;
END;
/

And for OS errors:

WHENEVER OSERROR EXIT FAILURE
START no_such_file

For more information, see this and that.

Hope it helps. Good Luck!

More Related Contents:

  1. Determining location of relevant tnsnames.ora file
  2. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  3. Oracle: Import CSV file
  4. When or Why to use a “SET DEFINE OFF” in Oracle Database
  5. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  6. SQL*Plus how to accept text variable from prompt?
  7. Convert epoch to date in sqlplus / Oracle
  8. oracle SQL plus how to end command in SQL file?
  9. How can I issue a single command from the command line through sql plus?
  10. How to View Oracle Stored Procedure using SQLPlus?
  11. How do I escape a reserved word in Oracle?
  12. How to put more than 1000 values into an Oracle IN clause [duplicate]
  13. ORA-30926: unable to get a stable set of rows in the source tables
  14. Fetch Oracle table type from stored procedure using JDBC
  15. “Safe” TO_NUMBER()
  16. error: ORA-65096: invalid common user or role name in oracle
  17. How to display table data more clearly in oracle sqlplus
  18. Oracle client ORA-12541: TNS:no listener [closed]
  19. Reason why oracle is case sensitive?
  20. Faster alternative in Oracle to SELECT COUNT(*) FROM sometable
  21. Oracle date difference to get number of years
  22. SQL Fiddle Output Error
  23. oracle PL/SQL how to calculate range ip for IPv6 cidr
  24. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  25. Oracle: how to add minutes to a timestamp?
  26. How to drop multiple interval partitions based on date?
  27. How to list active / open connections in Oracle?
  28. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  29. How to generate a version 4 (random) UUID on Oracle?
  30. Find out the history of SQL queries

Leave a Comment