Re: Verifying user/passwd from shell script?

>Hi there,
>
>I have to write a couple of shell scripts (ksh mainly) that call Oracle
>sqlplus. User/passwd-information for connection to Oracle is passed as a
>command line option. When I call sqlplus with invalid connection
>information, I get a prompt for a correct user/passwd combination. This,
>however, is entirely useless when my script runs in the background or if
>output goes to /dev/null or something similar. All the user sees is that
>nothing happens (slooow database today... :-( )
>
>Is there any way that I can find out from a shell script whether a given
>user/passwd combination is valid or not without hanging on an sqlplus
>prompt?
>
>Thanks very much,
>
>Martin
>

I don't know if SQLPLUS has an option like that - I seem to recall from a long time back that there was a -s option that suppressed some of the message (a "silent" mode). Maybe there is another option that does what you are looking for. Look in the SQLPLUS manual, looking for startup options.

Dan Hekimian-Williams Received on Fri Oct 29 1999 - 04:58:12 CEST