- Jan
- 2
- 0
Hi, just started using TC 16.0. Having problems with "Here Documents"
File ppp.bat works:
@ECHO OFF
SETLOCAL ENABLEDELAYEDEXPANSION
sqlplus -L -S system/dwed7g << endtext
select name from v$database;
exit;
endtext
File zzz.bat does not work:
@ECHO OFF
SETLOCAL ENABLEDELAYEDEXPANSION
SET ORACLE_BASE=G:\OPT\ORACLE
SET ORACLE_HOME=%ORACLE_BASE%\PRODUCT\112030
FOR /F %%A IN ('net start ^| findstr OracleService ^| sort') DO (
SET PIET=%%A
SET ORACLE_SID=%PIET:~13,10%
ECHO.
ECHO %ORACLE_SID%
sqlplus system/password@%ORACLE_SID% << endtext
select username from dba_users;
exit;
endtext
)
Errors received:
PD4A
TCC: (Sys) C:\Temp\for_active_services.bat [19] De parameter is onjuist.
"C:\Users\ITCHAL~1\AppData\Local\Temp\Ein88E2.tmp"
TDB11203
TCC: (Sys) C:\Temp\for_active_services.bat [19] De parameter is onjuist.
"C:\Users\ITCHAL~1\AppData\Local\Temp\Ein8902.tmp"
Can somebody please advice?
Thanks
Peter
File ppp.bat works:
@ECHO OFF
SETLOCAL ENABLEDELAYEDEXPANSION
sqlplus -L -S system/dwed7g << endtext
select name from v$database;
exit;
endtext
File zzz.bat does not work:
@ECHO OFF
SETLOCAL ENABLEDELAYEDEXPANSION
SET ORACLE_BASE=G:\OPT\ORACLE
SET ORACLE_HOME=%ORACLE_BASE%\PRODUCT\112030
FOR /F %%A IN ('net start ^| findstr OracleService ^| sort') DO (
SET PIET=%%A
SET ORACLE_SID=%PIET:~13,10%
ECHO.
ECHO %ORACLE_SID%
sqlplus system/password@%ORACLE_SID% << endtext
select username from dba_users;
exit;
endtext
)
Errors received:
PD4A
TCC: (Sys) C:\Temp\for_active_services.bat [19] De parameter is onjuist.
"C:\Users\ITCHAL~1\AppData\Local\Temp\Ein88E2.tmp"
TDB11203
TCC: (Sys) C:\Temp\for_active_services.bat [19] De parameter is onjuist.
"C:\Users\ITCHAL~1\AppData\Local\Temp\Ein8902.tmp"
Can somebody please advice?
Thanks
Peter