Home » Infrastructure » Windows » Batch file command not executing after for
Batch file command not executing after for [message #202121] Wed, 08 November 2006 04:42 Go to next message
laksha
Messages: 42
Registered: June 2006
Member
I have created a simple batch file as

sqlplus /nolog @trunc.sql
for %%f in (*.txt) do load %%f
sqlplus /nolog @drop.sql

In trunc.sql I am creating a sequence and using it in load.bat file.

In the drop.sql I drop the sequence.

When i run this batch file the third command "sqlplus /nolog @drop.sql" is not executed at all. Can someone please help?

The contents od load.bat are as under

echo DATA=%1 >>loader.par
echo log=loader_log.log >>loader.par
echo bad=loader.bad >>loader.par
echo discard=discard.log >>loader.par
echo skip=0 >>loader.par
echo rows=1 >>loader.par
echo bindsize=100000 >>loader.par
echo readsize=1000000 >>loader.par
echo direct=N >>loader.par
echo discardmax=100000000 >>loader.par
echo errors=1000000 >>loader.par
sqlldr control='loader_FH.ctl' parfile='loader.par'
sqlldr control='loader_BH.ctl' parfile='loader.par'
sqlldr control='loader_CD.ctl' parfile='loader.par'
sqlldr control='loader_DD.ctl' parfile='loader.par'
--del loader.par
sqlplus /nolog @abcd.sql
Re: Batch file command not executing after for [message #202128 is a reply to message #202121] Wed, 08 November 2006 05:07 Go to previous message
laksha
Messages: 42
Registered: June 2006
Member
Got that.used call.

for %%f in (*.txt) do call load %%f

Previous Topic: Problem in installing D2K (merged)
Next Topic: Oracle10g TableType changes 2 SYSTEM TABLE if "SYS" present in userName
Goto Forum:
  


Current Time: Thu Mar 28 13:47:08 CDT 2024