Re: Starting SQLPLUS with Prompted Username/Password

The shortcut target should only include the full path to the executable:   C:\ORAWIN95\BIN\PLUS33W.EXE To have your script run immediately after login, place the script filename '@c:\testscriptsql' in a file called login.sql. This file should reside in the target directory of the above mentioned shortcut.

Once sqlplus is executed, a login screen appears which prompts for a username/password/instance. If login is granted all commands in login.sql will be executed including your predefined @c:\testscriptsql.

Roy Hardin wrote:

> 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 Mon Mar 01 1999 - 16:13:46 CST