How to Parsing Variable value from SQLPLUS to Batch File
Hi,
I have some problem to parse the value from sqlplus to batch file.
This is my code
---------In abc.sql--------------
SET DEFINE '}'
variable vTemp VARCHAR2(1);
BEGIN
:vTemp :='AAA BBB CCC';
END;
/
exit :vTemp;
EXIT;
-----------------------------
-----in batch file -----------------------------
set jclid=%1
sqlplus.exe scott/tiger@db123 @D:\abc.sql
echo echo %errorlevel% --> how to get value return by vTemp ??
:END
----------------
My question is, how do i get the value of vTemp in batch file that returned by sqlplus.
Thanks,
Iwan