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

This isn't quite what you want, but might be useful. In SQL*Plus 9.2 the SQLPLUS -L command was introduced to not reprompt if the first connecttion fails. From the 9.2 release notes:

SQLPLUS -L Argument

There is a new command line argument for the SQLPLUS command, SQLPLUS -L which specifies not to reprompt for username or password if the initial connection does not succeed. This can be useful in operating-system scripts that must either succeed or fail. It is also useful for situations where you do not want to be reprompted for connection details if the Server is not running. This option is not available with the SQL*Plus for Windows graphical user interface.

Alison

samir wrote:
> Hi Thomas,
>
> Thanks a lot for such a detailed reply. It has really helped. To keep
> you updated, our operating system is Solaris. Now, as it is clear to me
> why the error is thrown, I need to implement the your idea of providing
> username and password for two more times to take care of service failure
> condition. It will be much better if somehow we can capture the return
> code from previous try and act accordingly.
>
> Thanks again for clarifying.
>
> with regards,
> samir
>
Received on Fri Apr 11 2003 - 00:02:10 CDT