Starting SQLPLUS with Prompted Username/Password

I need to set up a simple Win98 shortcut to start SqlPlus (windows) and run a script. Knowing the user name and password, this is trivial. However, I would like to prompt the person to enter their username and password.

Right now I am using (in shortcut target)

C:\ORAWIN95\BIN\PLUS33W.EXE username\password_at_db @c:\testscriptsql

(replace username, password and db with the correct one.)

This runs fine. But everyone has to have the same username in this case.

If I leave the username password out, it interprets the script file as part of the username/password and doesn't work. If I give it a bad username/password, it says invalid username/password and the prompts for the correct username/password.

What I would like to do is find out the syntax to place in the line so that the user is prompted for username/password automatically.

Thanks for any help.

Roy Received on Fri Feb 26 1999 - 10:51:47 CST