Re: problem with sqlplus and whenever error exit

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Wed, 22 Sep 1999 01:33:06 GMT
Message-ID: <37fa2d70.14743478@netnews.worldnet.att.net>

On Mon, 20 Sep 1999 15:02:13 GMT, pjbondi_at_SystemDatabase.com wrote:

>and my scripts have errors, but sqlplus does not exit. Any hints on
>what I might be doing wrong? Here is the output:
>
>Warning: Procedure created with compilation errors.

I'm willing to bet that this is expected behavior. Your statement actually executed sucessfully. Oracle attempted to create your procedure, and logged the compilation errors for you to see. From a certain point of view, that's success. Now if you had mangled the syntax of the CREATE PROCEDURE statement itself, then you would probably get the failure that you are expecting.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Tue Sep 21 1999 - 20:33:06 CDT