Re: A "sort of" Webserver question

Nicholas,

I'm working on something similar, except that I need to export two LONG fields to text files, run diff on them, and re-import the report for display on a web-page report.

My question is this: how did you generate the unique file names? Did you use the session number or some other method?

Thanks in advance,

Ken Nichols

nwhitehead_at_rocketmail.com wrote:
>
>
> We had this challenge on a project where we needed to have a very
> scalable report generator ( including graphics and drill downs ) that
> delivered reports to users on web browsers. Basically, we used Oracle
> web server which generates web pages dynamically from PL/SQL
> procedures and packages and allows HTTP requests to be "routed" to
> PL/SQL procedures.

<snip>

> The "Report Server" is a Oracle Reports process running in a loop and
> polling for DBMS_PIPES messages. When it gets a PIPE message, it
> unpacks it, determines which report has been requested and processes
> the parameters to generate the report. The final HTML/PDF file can
> either be stored on a file system ( a virtual directory for the web
> server ) using a unique file name or can be stored in the database.
>
Received on Wed Oct 08 1997 - 00:00:00 CDT