Oracle Forms call PL/SQL to open URL in browser to display jasper

[lori.stopka]

We have a software package written in oracle forms.  It prints purchase orders by calling an oracle stored procedure.  The stored procedure writes out a flat file on the server which is picked up by a separate process and printed.  This "separate process" is being obsoleted.  We would like to modify the oracle stored procedure to launch the jasper report passing in the necessary parameters so the browser is opened, the report displayed and the user can print it.

We do have forms that are opening jasper reports directly which just call a URL stored in a table but we don't know what the form is doing for those but it is working fine.

In this case the form calls the procedure and we can't modify the form.  We just want to change what the procedure does (eg:  launch browser and open jasper report URL).

I have been researching utl_http but not sure that will do it for us.

Any suggestions appreciated.

Thanks

Lori

[venugopal556]

I am not aware of  jasper reports ,but we are able to call database procedure /package using XMLDB.

The XMLDB HTTP listener routes the request to the embedded PL/SQL gateway as specified in its virtual path mapping configuration.

Regards

Venugopal