Call SQL*Plus [message #80152] |
Thu, 15 August 2002 15:21 |
Tyler
Messages: 123 Registered: January 2002
|
Senior Member |
|
|
Hello All,
I am trying to run a .sql, the windows association is SQL PLUS, so when I run the .sql, I want it to call sql*plus, but I get a "can't connect to destination" because it needs a pwd, so it brings up the sign in box. But after signing in, it doesn't execute the .sql, it just gives a SQL> prompt, is there a way to pass a parameter user_name, pwd, and connct string, so that it executes the .sql right away?
|
|
|
Re: Call SQL*Plus [message #80156 is a reply to message #80152] |
Thu, 15 August 2002 23:02 |
Victoria
Messages: 152 Registered: July 2002
|
Senior Member |
|
|
you can append ur user Id and password with the sqlplus statement as
sqlplus UserID/Password@connectionstring
Regards
Victoria
|
|
|