2 Replies Latest reply: Jul 27, 2011 2:23 PM by xerces8 RSS

    Script error not printed with WHENEVER OSERROR EXIT

    xerces8
      Hi!

      I run a script with SQL*Plus and noticed, that the script does not stop on an error like this:
      SP2-0310: unable to open file "../../some_script.sql"


      I added a line of:
      WHENEVER OSERROR EXIT

      And then it exits on error, but now the error message is not printed.
      So it looks like the script was finished successfully.

      Is there a way to get both?
      The error message and a stop to the script execution?


      Version:

      SQL*Plus: Release 10.2.0.3.0 - Production on Tue Jul 19 19:05:26 2011

      on Windows XP


      Regards,
      David Balažic