Home » RDBMS Server » Server Administration » Invoking SQL*Plus from a DOS batch file
Invoking SQL*Plus from a DOS batch file [message #371214] Mon, 18 September 2000 12:54 Go to next message
Deborah Welch
Messages: 7
Registered: September 2000
Junior Member
I have DOS batch file that starts SQL*Plus and connects.
The batch file also builds a '.sql' file with SQL*Plus commands.
The problem is the SQL select statement I want to execute has a ">"
operator in it, and DOS is interpreting that symbol as direction for
an output file.
Any experience out there with doing this sort of thing? As a work-around, I had modified the SQL to say '=! 0', but this is kludgy.
Thanks in advance,

Report message to a moderator

Re: Invoking SQL*Plus from a DOS batch file [message #371215 is a reply to message #371214] Tue, 19 September 2000 03:47 Go to previous message
Mahesh Pednekar
Messages: 28
Registered: August 2000
Junior Member
Try out following command with exact path of sqlplusw.exe file

c:\Oracle\Ora81\BIN\SQLPLUSW.EXE

Report message to a moderator

Previous Topic: oci 8i binding
Next Topic: form 6/IE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 12:30:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.