Re: ANyone use Oraperl a LOT

sjs_at_netcom.com (Stephen Schow) writes:

>I would like feedback from people who use Oraperl for "IMPORTANT" company
>systems and projects. Do you use it? I know its just fine for one time
>jobs and short term jobs. But what about for long term...long standing
>projects. For example, if I need to use something like Oraperl or PL/SQL
>to implement a report that will be used for several years. What do you think
>of that? The hardware that this report is running on may very well change
>within that time. The OS may be upgraded, etc..
 

>Oraperl clearly has some features that would really help me out for this
>project, but I am a little scared to use it for a project like this.
 

>Comments?

Can't argue with you there (about being scared).

I've got a client where quite a bit of Oracle stuff "happens". I think that they're up around 20,000 MB (and growing daily). They're running HP 9000/827's (three or so, SQL/NET, etc). I installed oraperl and everything seemed pretty cool, until I tried to do an "UPDATE ..." and it kept telling me that my statement was improperly terminated (SQL/PLUS and then PRO*C both liked it with no changes.

Then a comparison of output with SQLPLUS output showed that sometimes rows just didn't show up when the same query was executed.

They decided that they didn't want to have anyone debug or maintain oraperl.

Since I had already coded up a ~2000 line oraperl program (script?) I converted it to PRO*C. Took the better part of a day.

I can certainly see its utility in doing quick and dirty prototype things.

-- 
Steven C. Monroe            VOICE:(703)406-2082                PC Three, Inc.
scum_at_pcthree.com             FAX:(703)406-2078                  P.O. Box 1644
                                                              Herndon, VA 22070