Re: SQL*Plus question

Mike Gold <Michael.Gold_at_DaytonOH.NCR.Com> writes:  

> When I execute a UNIX shell, which has a call to SQL*Plus and
> includes a username/passwrod and an executable SQL file
>
> (sqlplus username/login _at_runfile.sql)
>
> if the SQL username/password is invalid, and the UNIX script is
> running in the background; a prompt for a correct username/password is
> generated by ORACLE, but is never seen. Is there any way to
> specify on the SQL*Plus command line that if the username/password is
> invalid, that SQL*Plus should NOT prompt for a valid login?

How about:

     sqlplus username/login _at_runfile.sql </dev/null

If login is invalid, sqlplus tries to read from stdin and gets an end-of-file which causes it to exit.

--
Bob Poortinga (mailto:bobp_at_tsc.com, http://www.tsc.com/~bobp)
Technology Service Corp. (http://www.tsc.com)
Bloomington, Indiana  USA