I'm just facing one request from client - automatically generated PDF files whose will be stored in database (in www_flow_files).
I'm using for PDF standard report engine with Apache FOP. It works. But, the result (generated PDF) is "pushed" into client computer and I don't know how can I call report query via pl/sql to store data. I've tried to use package utl_http.get_response with link to page 0 and report query, but I wasn't successful, because I'm faced strange problems with SESSION_ID.
After that I've tried to go via db packages (directly), I have found package wwv_flow_render_query, but it's not documented :(