rem @echo off
SET ORA_USR=%1
SET ORA_PWD=%2
SET ORA_TARGET_DBSTR=%3
SET NLS_LANG=AMERICAN_AMERICA.TH8TISASCII
SET SQL_DIR=%4
SET SQL_DIR_BAK=%5
mkdir %SQL_DIR%
cd %SQL_DIR%
for /f "eol=: delims=" %%F in ('dir /o:d /b *.sql') do (
    rem echo %%F
	echo quit|echo commit;|sqlplus %ORA_USR%/%ORA_PWD%@%ORA_TARGET_DBSTR% @%%F > %%F.log
	move %%F %SQL_DIR_BAK%
	move %%F.log %SQL_DIR_BAK%	
)

rem for /r %%i in (*.sql) do echo quit|echo commit;|sqlplus %ORA_USR%/%ORA_PWD%@%ORA_TARGET_DBSTR% @%%i
rem for /r %%i in (*.sql) do move %%i %SQL_DIR_BAK%
rem SET /P P=