How to generate a PDF output using batch file in 10G
IQApr 13 2011 — edited Apr 13 2011Hello,
I am using .bat file to generate a report PDF output. I have done this many times in 6i but for 10G I am unable to do the same.
Can someone please look at the syntax below and let me know where I am going wrong.
I understand that reports are different for 6i and 10G specially .rep file but I am sure we should be able to generate a PDF file using 10G. Please let me know.
Thanks
IQ
Contents of .bat file follow
------------------------------------------------------------------------------------------------
ECHO Opening parameter form. Please do not close this window.
C:\
FOR /F "tokens=1 " %%I IN ('time /t') DO (SET _TIME=%%I)
FOR /F "tokens=2 " %%I IN ('date /t') DO (SET _DATE=%%I)
SET EXP_DATE=%_DATE:~6,4%%_DATE:~0,2%%_DATE:~3,2%_%_TIME:~0,2%%_TIME:~3,2%
SET FILENAME=SEND_EMAIL_%EXP_DATE%_%USERNAME%.PDF
CD C:\Users\Documents
RWCONVERTER REPORT=C:\Users\Documents\send_email.rep USERID=scott/tiger@ORCL1 ORIENTATION=LANDSCAPE DESFORMAT=PDF DESTYPE=FILE
DESNAME=C:\Users\\%FILENAME% PRINTJOB =NO