This discussion is archived
2 Replies Latest reply: Jul 27, 2011 12:23 PM by xerces8 RSS

Script error not printed with WHENEVER OSERROR EXIT

xerces8 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points