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

[Quoted] 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?

Richard

Christopher.Jones_at_oracle.comX wrote:
>
> Richard Kuhler <noone_at_nowhere.com> writes:
>
> > FYI, I typically use this logon sequence as the top of batch scripts ...
> >
> > scott/tiger_at_orcl
> > --/--
> > --/--
> >
> > If the login is successful then those are treated as comments otherwise
> > they fail as login attempts and the script exits. Just seems a little
> > clearer to me but decide for yourself.
>
> In SQL*Plus 9.2 the -L option to SQL*Plus removes the need for the
> second and third line. See:
>
> http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a90842/ch4.htm#1005887
>
> A WHENEVER SQLPLUSERROR command has been mooted before, (Metalink
> users can see enhancement 429330. See also 518123).
>
> Chris
>
> --
> Christopher Jones, Oracle Corporation, Australia.
Received on Wed Oct 09 2002 - 20:32:23 CEST