Oracle batch script issue

[PAVB]

Try this...

@echo on
FOR /f "tokens=1" %%i in (C:\Jc\joblist.txt) do (
echo %%i
sqlplus -s w951gxd@DWTST01/mcgi05 <<-ENDSQL 
SET heading off
SET pagesize 80
SET MARKUP HTML ON SPOOL ON HEAD " - STYLE TYPE=’TEXT/CSS’>"
SET ECHO OFF
SPOOL "C:\Jc\Reports\%%i.htm"
select REPORT_TEXT from TB_JOB_REPORT where jobname = '%%i' ;
SPOOL OFF
SET MARKUP HTML OFF
SET ECHO ON
ENDSQL
)

[Murthy12345]

Hi,

i created a one batch script , inside it calls some SQL functions but when i execute that script am not able to connect sqlplus , SQl*Plus commands are not working ..

please look my below script and give some suggestions???

@echo on
FOR /f "tokens=1" %%i in (C:\Jc\joblist.txt) do (
echo %%i
sqlplus connect w951gxd@DWTST01/mcgi05
SET heading off
SET pagesize 80
SET MARKUP HTML ON SPOOL ON HEAD " - STYLE TYPE=’TEXT/CSS’>"
SET ECHO OFF
SPOOL "C:\Jc\Reports\%%i.htm"
select REPORT_TEXT from TB_JOB_REPORT where jobname = '%%i' ;
SPOOL OFF
SET MARKUP HTML OFF
SET ECHO ON

)

[LKBrwn_DBA]

Try this:

@echo on
FOR /f "tokens=1" %%i in (C:\Jc\joblist.txt) do (
  echo %%i
  set jobid=%%i
  call :sqlplus
)
:sqlplus
(
echo set head off pages 80 echo off
echo SET MARKUP HTML ON SPOOL ON HEAD " - STYLE TYPE=’TEXT/CSS’>"
echo SPOOL C:\Jc\Reports\%jobid%.htm"
echo SELECT report_text FROM tb_job_report WHERE jobname = '%jobid%' ;
echo SPOOL OFF
echo SET MARKUP HTML OFF
echo exit
) | sqlplus w951gxd@DWTST01/mcgi05
:endproc

[Murthy12345]

Hi LKBrwn_DBA,

i tried with that code, its running fine but i cant see any reports in the directory C:\Jc\Reports\

[LKBrwn_DBA]

Try removing the trailing quote (") from:

...etc...
echo SPOOL C:\Jc\Reports\%jobid%.htm"
...etc...