@echo off

set /p oracle_dir="input oracle directory: "

set /p oracle_path="input oracle path: "

set /p oracle_user="input user who you grant write,read on directory: "

set sql_path="."

set /p flag="execute Y|N: "


if  %flag%==Y (sqlplus / as sysdba @%sql_path%\create_dir.sql %oracle_dir% %oracle_path% %oracle_user% )