OraFAQ Forum: Reports & Discoverer » How to call oracle reports inside a stored procedure.

Home » Developer & Programmer » Reports & Discoverer » How to call oracle reports inside a stored procedure. (oracle 9i, oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to call oracle reports inside a stored procedure. [message #479022]

Thu, 14 October 2010 05:07

rajesh4851
Messages: 89
Registered: January 2007

Member

Hi,
We have one requirement.
Currently some jobs created in WBT scripting need to converted into oracle,plsql.

There is one job in WBT scripting, which will invoke the oracle reports inside and generate the PDF files in the destination path as follows:

a = runhide("c:\Program Files\Internet Explorer\iexplore.exe", "http://pscm9722:7778/reports/rwservlet?USERID=%LOGONINFO%+server=rep_pscm9722+destype=file+desname=D:\ORACLE10G\%CCALLRptName%+desformat=PDF+PARAMFORM=no+report=PCCALL.RDF")
a = runhide("c:\Program Files\Internet Explorer\iexplore.exe", "http://pscm9722:7778/reports/rwservlet?USERID=%LOGONINFO%+server=rep_pscm9722+destype=file+desname=D:\ORACLE10G\%CCDAILYRptName%+desformat=PDF+PARAMFORM=no+report=PCCDAILY.RDF")
a = runhide("c:\Program Files\Internet Explorer\iexplore.exe", "http://pscm9722:7778/reports/rwservlet?USERID=%LOGONINFO%+server=rep_pscm9722+destype=file+desname=D:\ORACLE10G\%CHKEXTRARptName%+desformat=PDF+PARAMFORM=no+report=PCHKEXTRA.RDF")
TimeDelay(10)

Now, i want to convert this into oracle,plsql? Is it possible or not?
Pls suggest me a good idea .

Regards,
Raj

Report message to a moderator