RE: :) What you can't do in java you can do in perl

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Wed, 29 Sep 2004 10:10:36 -0500
Message-ID: <433A07749711884D8032B6A0AB115262C2BDC8@conmsx07.corp.acxiom.net>

Wolfgang,

Couldn't you use SED to convert the EOF marker to something else you could recognize with PERL? Then you could code PERL to handle that.

Larry

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Wolfgang Breitling Sent: Wednesday, September 29, 2004 9:37 AM To: oracle-l_at_freelists.org
Subject: Re: :) What you can't do in java you can do in perl

I am no expert in either Java or Perl, far from it. But then I'm not a developer. However I use Perl quite a bit to do file manipulation such as process trace files. There it is just faster than Java, both in terms of development time but also in execution time. It runs rings around Java - and

most anything else.
The same goes for repetitive database monitoring tasks. I do those either as

PL/SQL database jobs or Perl scripts which have the repetition internal to avoid frequent connects to the database.

There is one task where I invested some time to develop a Java class because

Perl let me down and that is to extract the "dbms_stats.set_xxx_stats" commands
from an export file. Those records contain length fields and invariably one of
those length fields is interpreted by Perl as end-of-file and it stops. If someone knows how to work around that in Perl I'll gladly ditch the Java class -
it also still has a problem where it sometimes gets confused by those length
fields. But I am not using it that often that it has been worth my time to go
back and debug it, or even so desperate to try my hand at C.

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.
If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 29 2004 - 10:08:57 CDT