Hello Friends.
I am using Apex 4.1 on Windows 7. My database is Oracle EE 10.2.0.5 on Solaris and OAS as the app server (and so, am using mod_plsql).
I wrote an application in which I use the PLPDF package to generate PDF screens. Initially, the last few commands in my code looked like:
owa_util.mime_header('application/pdf',false);
htp.p('Content-Length: ' || dbms_lob.getlength(l_blob));
owa_util.http_header_close;
wpg_docload.download_file(l_blob);
The variable
l_blob is the PDF blob object generated by PLPDF. The PDF is being formed from a cursor for loop further up in my code (not displayed here) that is SELECTing from a table. The above code displays the generated PDF on to a popup page in my application. At that point, the user can click the "File->Print" menu to send the displayed PDFF to the default printer.
However, my requirements are that I may have multiple PDFs generated from my for loop and would like to have each of these PDFs sent to the default printer is one go rather than force the user to have to display and print each one separatlely.
And so I modified the above code so that the PDFs created by the PLPDF package are being inserted into an Oracle table rather than displayed in a popup page.
Would any one know how to send each of the PDFs stored in the table to the default printer automagically, perhaps my issuing a
ctrl+p command or some such thing.
Thanks in advance for any help/code/advice.
Elie