| Batch file command not executing after for [message #202121] |
Wed, 08 November 2006 04:42  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
