Recordset to HTML table

From: Matt Riggsby <Matthew.Riggsby_at_novainfo.com>
Date: 8 Apr 2003 06:24:50 -0700
Message-ID: <397b5de2.0304080524.553d24f5_at_posting.google.com>


At the moment, we're using ASP pages and VBScript to produce some reports from our Oracle database. The pages run a stored procedure which gets a record set from the Oracle server, format it as HTML, and go back to save the results as a CLOB in case anybody wants to see the same report with the same parameters again. The problem is that the performance of these reports bites because of the back-and-forth between servers and browser. The queries in the stored procedures actually run at a reasonable speed, so it crossed my mind that we'd get much better performance if we let the Oracle server do the heavy lifting and just pass finished results to IIS.

What I'd like to do, then, is take the results of a stored procedure
(which returns a cursor-type value), format them as HTML, and save
those results in the database, using only methods within Oracle. Is there any relatively painless way of doing that, or would I have to code up something different for each possible query?

(And please don't ask me why we're not using Crystal Reports or some
other real reporting package; I'll just start to cry.) Received on Tue Apr 08 2003 - 15:24:50 CEST

Original text of this message