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

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