got it to work...forgot to put ";" in the sql file :-)
I guess I should have expanded on the real reason i want to do this, I have a cmd that is as such right now:
for /f "delims=" %%a in ('sqlplus user/pass@OMP1 @CheckRowCount.SQL') do set rowcount=%%a
if %ROWCOUNT% GTR 0 (
c:\Autobatch\Spotfire.Dxp.Automation.ClientJobSender.exe http://staom.sec.samsung.net:8070/spotfireautomation/JobExecutor.asmx c:\AutoBatch\backup\Trigger_Test.xml
but I don't get anything. All I get is a blank CMD window that opens
You have to use sql terminator or else use /(backslash) to execute the query or else search login.sql file in oracle home directory and make necessary changes so that next time it will execute the query without any terminator or backslash ..