#1
|
|||
|
|||
How do you run script using Oracle SQL Develloper silently?
I am having trouble running Oracle SQL Developer silently. I am trying to run a sql script file using the 'Run Program' action step and I entered the following on the Command field:
"C:\SQL Developer\sqldeveloper-1.1.2.2579\sqldeveloper\sqldeveloper.exe" sqlplus "username/password@oracleserver" Note, the username, password and oracleserver are the values I enter accordingly (no spaces, no quotes). On the Input tab, I enter the .sql file name. I also entered it as a string, as in @C:\FILEPATH\FILENAME.sql and the oracle program just opens up, it doesn't even run the script file. I have been unsuccessful in running the script file every time. I am able to do this by calling the command prompt (cmd.exe, by using the %DOSCMD% system macro) but not this way. Any help would be greatly appreciated. Thanks. |
|
|