Re: sqlplus behaviour clarification : "could not resolve service name"

"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message news:MPG.18ff8b4c53bc012b98972f_at_news.la.sbcglobal.net...
> Since you indicate that you're using a shell script, can you do
> something like the following?
>
> sqlplus -s /nolog <<endsql
> whenever sqlerror exit
> connect x/y_at_db
> @mysql
> endsql
>
> If the connect fails, you'll get an error, but won't execute mysql.sql
> (because of the whenever sqlerror).
> --
> /Karsten
> DBA > retired > DBA

Karsten, thanks for that bit of info; I didn't know about that command! It's much cleaner then my suggestion was!! In fact, I'm already thinking of ways to use that command in some of my own SQL's!

-Thomas Received on Thu Apr 10 2003 - 20:28:36 CDT