Re: Checking Oracle USR/PWD by a Unix shell [message #374841] |
Thu, 05 July 2001 17:23 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
I don't know of any way of making sqlplus exit after the first attempt. What you could try is placing "exit 1" in the sql file. This way I guess you will get "1" returned if the sql file is successfully executed (i.e. logon was possible). Another trick is the end the sql file with a dummy spool file. When you return to Unix shell, you check for the file.
e.g.
... sql statements...
spool my_sql_file_executed_ok.lst
spool off
|
|
|