Store Bi Publisher Output PDF to a Table's BLOB column
Hi,
My current Report Generation Process using Bi Publisher is as Follows:
- Concurrent request calls a procedure which dumps the relevant data into the temp table
- The procedure submits another concurrent request which uses an executable "
XDODTEXE" to generate a PDF report.
I now have a requirement to save the output generated to a table along with some other request parameters.
To that end, I am extracting the out_filename from fnd_concurrent_program for a given request_id. And I have already defined the directory REPORT_DIR where the output PDF file name is being saved.
After that the code is as follows:
Tagged:
0