Oracle Forms

Hi,

My problem in short is this - from Forms I would like to run a report on our application server and transfer the resulting PDF file directly to the database server, either as a blob in a table on directly to a folder, it really doesn't matter. The main point is to do this without putting load on the client's network traffic, by for example downloading and uploading the file. We run forms in a windows environment, and the applications and database servers are in unix, on two separate machines. Forms and Reports are both at 10g

To put the problem into context;

I'm tasked with improving the performance of our forms application that we run from Asia (the database being located in Sweden). The main issue has proven to be unnecessary network load. One such is the handling of emailing reports. The client form (run from Asia) needs to send an email, attached with a report created at runtime, along with some rather big blob files from the database (located in Sweden). Thus, the mail procedure needs to happen directly in the database to avoid having to download the other attachments to the client. What's missing is the PDF report.

At the moment, when sending emails we do the following:
1. Run report with Destype & Desname, placing the report on the application server.
2. Download the report locally to the client (Placing it in the Temp Directory through webutil_file_transfer.AS_To_Client)
3. Upload the report to the DB-server (Through Webutil_File_Transfer.Client_To_DB)
4. Send the email from the DB.

A PDF file of 200kb takes roughly 40 seconds to transfer from the application server to the client and then to the database through this method. The problem here are step 2 and 3, which I would in some way want to replace with just transferring it from the Application server directly to the Database server.

Any help is greatly appreciated. Thanks in advance
Jonas


PS: I'm sorry if I haven't posted this in the correct forum section. I wasn't entirely sure what this should be labled as, since it's server, Forms and Reports related... But as it's basis is Forms, so I've put it here