Home » Developer & Programmer » Forms » Call SQL*Plus
Call SQL*Plus [message #80152] Thu, 15 August 2002 15:21 Go to next message
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 Go to previous message
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
Previous Topic: How do i show data from a table in a block
Next Topic: how can i change text item background property only when i update data
Goto Forum:
  


Current Time: Thu Apr 25 16:18:31 CDT 2024