Re: Grrr! How do you make sqlplus exit on a syntax error!

Niall Litchfield wrote:

> <Christopher.Jones_at_oracle.comX> wrote in message
> news:un0pn2dc4.fsf_at_oracle.comX...
> > Richard Kuhler <noone_at_nowhere.com> writes:
> >
> > > I can't find those enhancements. I'm looking on the "Oracle Enhancement
> > > Request System" (ers.oracle.com) using those numbers (429330, 518123) as
> > > the "Enhancement ID" for the search. Note that ERS is accessible with a
> > > technet account but I couldn't find anything on Metalink either.
> > >
> > > Where are these exactly?
> >
> > I found them in ERS after I wound the "Created after" date back to
> > 1996.
> >
> > 429330 is the request for WHENEVER SQLPLUSERROR.
>
> This was last updated in 1997 with a 'pass to external user group for
> comments' status. Did this ever get done? If so I assume this enhancement
> has effectively been rejected.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************

I'll try again.

What's wrong with:

BEGIN

[Quoted]    ... your SQL statement here
   ... your SQL statement here
   ... your SQL statement here

Seems to me the functionality requested already exists. Just wrap BEGIN and END [Quoted] around your SQL.

Daniel Morgan Received on Thu Oct 10 2002 - 19:53:24 CEST