SqlPlus does't execute in a batch loop, why?

Question

I made a batch script that iterates recursively through all the .sql files under a directory. My problem is that i can echo all the files treated correctly with this version :

 @for /r "%PWD%\06-Instalaciones" %%a in (*.sql) do (IF "C:%%~pa" NEQ "%PWD%06-Instalaciones\ProximaInstalacion\" echo %%~fa )

But i cant seem to sucessfully call SqlPlus instead of the echo, for every sql file treated :

@for /r "%PWD%\06-Instalaciones" %%a in (*.sql) do (IF "C:%%~pa" NEQ "%PWD%06-Instalaciones\ProximaInstalacion\" %ORACLE_HOME%/bin/sqlplus -L -S FOO/BAR@%sid% @%%~fa)

I get the following error : "(HOST was unexpected at this time.".

Thank you.

Try writing echo before %ORACLE_HOME%/bin/..., to see what the command expands to, and if there is a parameter with spaces that needs quoting. — angus
– angus, Commented Nov 19, 2013 at 12:23
I tried what u said and the %%~fa aint expanding. If need to wrap the whole SqlPlus call in quotes for it to work, but then SqlPlus doesnt execute. — Negashion
– Negashion, Commented Nov 19, 2013 at 12:53
Try using another letter, for example %%G, since %~fa already has the meaning filename + attributes. — angus
– angus, Commented Nov 19, 2013 at 13:03
I can't expand %%G,if i repeat the echoing and quoting process i get %G. — Negashion
– Negashion, Commented Nov 19, 2013 at 13:10
I tried with %%f : @for /r "%PWD%\06-Instalaciones" %%f in (*.sql) do (IF "C:%%~pf" NEQ "%PWD%06-Instalaciones\ProximaInstalacion\" %ORACLE_HOME%/bin/sqlplus -L -S FOO/BAR@%sid% @%%~f >> log.txt) — Negashion
– Negashion, Commented Nov 19, 2013 at 13:53

Negashion · Accepted Answer · 2013-11-19 14:06:02Z

1

Thanks to angus for pointing out my error. I had a space in one of my variables!!! Particularly in %sid%. I'll leave here my code in case someone needs it :

@echo off
@SET PWD=%~dp0
@SET sid=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))(CONNECT_DATA=(SERVER=dedicated)(SID=xxxxx))) 
@for /r "%PWD%\06-Instalaciones" %%f in (*.sql) do (IF "C:%%~pf" NEQ "%PWD%06-Instalaciones\ProximaInstalacion\" %ORACLE_HOME%/bin/sqlplus -L -S FOO/BAR@"%sid%" @%%~f >> log.txt)

answered Nov 19, 2013 at 14:06

Negashion

1391 silver badge13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SqlPlus does't execute in a batch loop, why?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related