Re: Has anyone used PL/SQL to generate reports

On Mon, 05 Mar 2001 15:00:44 -0500, NeedaHoliday wrote:

>I have a whole backend batch process that is developed in PL/SQL. I
>use Pro C to generate report from the processed data. Has anyone ever
>used PL/SQL to generate reports and what is the command to create the
>output line?
>
>Thanks
Utl_file.put_line

owever, this would be an extreemly labor intensive solution and inflexible solution as you would need to program *everything* and in Oracle Reports, a non-procedural tool, you don't need to do that. I would recommend using pl/sql as a report tool, maybe sql*plus itself. If you can't afford Oracle Reports you may want to look at Crystal Reports and/or Structured Query Reportwriter (SQR).

Hth

Sybrand Bakker, Oracle DBA Received on Mon Mar 05 2001 - 23:30:03 CET