Forum Discussion
tristaanogre
15 years agoEsteemed Contributor
The concept is going to be the same as before. However, the difference being before you were using the CMD.EXE to run SQLCMD.EXE. So, now you are trying to run SQLPLUS.EXE. You'll need to do pretty much what you did before in your command string. Essentially, if you were to open up CMD.EXE, what would you type at the command prompt there to execute your SQL query?
I'm not familiar with SQLPLUS.EXE but in the brief reading out there, it seems that it does not support command-line parameters like SQLCMD.EXE or OSQL.EXE does. If you wish to execute a query against your Oracle DB, you'll need to find a similar tool to SQLCMD.EXE to utilize the shell as we did with the other SQL query.
I'm not familiar with SQLPLUS.EXE but in the brief reading out there, it seems that it does not support command-line parameters like SQLCMD.EXE or OSQL.EXE does. If you wish to execute a query against your Oracle DB, you'll need to find a similar tool to SQLCMD.EXE to utilize the shell as we did with the other SQL query.