Re: WHENEVER SQLERROR doesn't work?

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 23 Mar 2001 21:09:24 -0800
Message-ID: <3ABC2C04.3A626AD0@exesolutions.com>

I understand now. Gerard's answer should solve the problem.

Dan Morgan

> > Your syntax is new to me. What I'm used to seeing is:
> >
> > CREATE OR REPLACE PROCEDURE xyz IS
> >
> > BEGIN
> >
> > EXCEPTION
> > WHEN the_exception THEN
> > do_something;
> >
> > END;
> >
> > And I can guarantee you that when written this way it will always exit the
> > procedure.
> >
>
> Misunderstanding. I want to exit when the error occures on the compilation
> time (not runtime) - when I load file myscript.sql into Oracle using SQLPLUS.
>
> Tomasz
Received on Fri Mar 23 2001 - 23:09:24 CST