Re: Oraperl Vs. PL/SQL, ReportWriter
Date: 3 Feb 1995 01:21:06 GMT
Message-ID: <3gs0e2$qj0_at_pearl.whoi.edu>
Arthur Yasinski (ayasinsk_at_nofc.forestry.ca) wrote:
: In article t4j_at_netnews.upenn.edu, egedi_at_linc.cis.upenn.edu (Dania M. Egedi) writes:
: >Has anybody used both oraperl and PL/SQL and did they find them
: >roughly equal? How would you compare the two? I would greatly
: >appreciate any input regarding this questions.
: >
: >I also have a second question.....
: >
: >I need to generate some reports to print out the results of the
: >application run. I have had some experience with SQL*REPORT (I don't
: >recall the version). It was only a text based application and was
: >very simplistic (as I recall). I understand that Oracle has a new
: >version of SQL*Report and that it is much better. Has anyone used
: >it and is it really better?
: To answer both questions in one fell swoop:
: * years ago when SQL*ReportWriter was (as you mentioned) very simplistic,
: we required very professional, flexible, PostScript reports. We wrote
: tonnes of Pro*C programs to format the data in groff (troff, but gnu) and
: produce the PostScript as well as text output.
: * last year we migrated most of those programs to oraperl scripts, and found
: oraperl 100 times nicer. There is no more worrying about mallocs, frees,
: etc., and everything else. Especially since all we were doing was string
: manipulations, C was overkill.
: We now write almost every external app, that we would would have previously written
: in Pro*C, in oraperl.
I agree. I have written over 10,000 lines of Oraperl code and simply love it. I played with PL/SQL a little and the more I used it, the more I hated it. I've been spoiled by Oraperl. :)
I've even written my own menu'ing and forms package in "coraperl" (Curses+Perl+Oracle). I have pre and post field checks which allow me to use the Perl language to do my data checking. It works like a charm. Drawback to Forms is you have to use PL/SQL as the driving language.
I admit I worry about Oraperl with every upgrade to Oracle, but I'm looking to the new DBPerl to have a bigger following and therefore more support. Somebody out there on the net usually has gotten Oraperl to compile under the latest version of Oracle.
David Hiltz
dhiltz_at_whsun1.wh.whoi.edu
Unix System Administrator
Northeast Fisheries Science Center
######&_at_&###### Received on Fri Feb 03 1995 - 02:21:06 CET