Originally posted by dps
Unfortunately the login script when used by my desktop icon takes while to work and then starts up with the SQL>

your second peice prompts me for a value but then disconnects from oracle.....

The script which I have shown above - the one which is currently picked up by my sqlplus desktop icon - does the job I want so far as in that the prompt tells me which dbase eg.

dps_cc@test_dbase>
Above the uname would be dps_cc and passwd dps_cc

then I do the following : -

dps_cc@test_dbase> connect dps_nms@live_dbase
Enter password: dps_nms
Connected.
dps_cc@test_dbase>
*****the above prompt should now be dps_nms@live_dbase> not "dps_cc@test_dbase>" ****

Hope this clearifies it

Thanks in advance
read the post, I put @conn USERNAME@TNS not username/password@tns

look conn.sql

have you noticed I have set a SQLPATH variable... do you have that?