Windows & DOS: Issues & Discussions

cls
@echo off
echo.
echo ======================
echo EXECUTING POST SCRIPT 
echo ======================
echo.
SET /p username=Enter username:
echo.
SET /p password=Enter password:
echo.
SET /p path=Enter script path:
echo.
cd %oracle_home%\bin 
sqlplus "%username%/%password%" @%path%post_script.sql
SET username="a"
SET password="b"
SET tnsname="z"
cd \

%username%
%path%

cls
@echo off
echo.
echo ======================
echo EXECUTING POST SCRIPT 
echo ======================
echo.

:username
SET /p username_=Enter username:
if not defined username_ (goto:username)
echo.

:pass
SET /p password=Enter password:
if not defined password (goto:pass)
echo.

:path
SET /p path_=Enter script path:
if not defined path_ (goto:path)
echo.
cd /d "%oracle_home%\bin" || (
	echo Error cambiando de directorio
	exit /b 1
	)
	
sqlplus "%username%/%password%" %path%post_script.sql
SET username="a"
SET password="b"
SET tnsname="z"
cd \