Has someone already created a way to send a URL to a jasper server from within an Oracle stored procedure?

[nancy.faircloth]

I am newborn to Jasper, coming from Oracle Reports; we currently have a stored procedure running nightly that uses HTTP utility to send the URL to the reports server with parameters to save the output in a Linux filesystem.  The series of Oracle Reports paramenters look like the string below; is there an equivalent call to the Jasper Reports server?

"http://hostname:port/reports/rwservlet?server=RptSvr_r3&report=DELIVERABLE_LGL_RPT.rdf
&userid=userID/pwd@ORCL
&destype=FILE
&desformat=pdf
&desname=/my_absolute/file_path/LK181_JAN_2016_DELIV.pdf
&myparm_contract='LLKLL'
&myparm_report_beg_d='1/1/2016'
&myparm_report_end_d='1/31/2016'

I am grateful for any direction I can get!

[javier.ggi90]

Don't know your exact route to the report but lets just say you run a report. Now, copy the URL and at the end add:

&parameter_id=value&parameter_id2=value2.....&parameter_idx=valuex

[hozawa]

Does Oracle Report save a pdf file to a linux file system just by calling that URL or it is returning  pdf file?

JasperReports Server professional version is able to save a scheduled report to a file system but a community edition may not.

JasperReports Server (both professional and community editions) support web api's so users would be able to generate reports but the report is sent back as a reply to the request. Just attach j_username and j_password to the uri.

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-web-services-guide/v62/running-report