Those things, and its got a much better return on investment in terms of extensibility. As a systems chappie, I started out writing things in shell scripts, small C programs, etc. But I noticed that every time I did anything that provided information (ran a report, data aggregation, log mining, etc.), people always wanted it extended - "Oh, that's a really neat bandwidth report, Matt. Now could you make it into a web application?" "Oh, that web app is neat - could you have it page people when the current bandwidth utilization exceeds a certain amount?", etc. etc. Well, a lot of those things are much harder in C or shell scripts than they are in Perl. So I just started writing everything in Perl if I thought it was going to be run more than a few times - it just makes it much easier to grow your scripts to add functionality you never initially anticipated.
Plus the syntax is much more flexible (read: lazier) than C, so it saves time. Interestingly enough, there are organizations that are starting to decide that the perl's syntactical flexibility is a negative - look at Yahoo's choice of PHP for its long-term application platform. They said, among other things, that they were concerned about enforcing coding standards in a Perl environment. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Richard Ji > Sent: Wednesday, July 09, 2003 10:55 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: RE: utl_file on Redhat Linux Oracle 9 standard engine > > > Simpler, portability > > Richard > > -----Original Message----- > Sent: Wednesday, July 09, 2003 10:04 AM > To: Multiple recipients of list ORACLE-L > > > seems like alot of long time DBAs prefer using perl over > pro*c to do data loads and unloads. is it just because its > simpler? or is it more robust? or other reasons? > > > > > > From: "Cary Millsap" <[EMAIL PROTECTED]> > > Date: 2003/07/09 Wed AM 09:44:25 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: RE: utl_file on Redhat Linux Oracle 9 standard engine > > > > John, > > > > UTL_FILE is one of the worst designed functions I've ever tried to > > use. > > > > In my opinion, it's a major design flaw to use the newline > character > > ('\n') as a packet delimiter. If UTL_FILE gets input lines that are > > "too long" (too many bytes between '\n' characters), you'll get an > > error. If you have short lines in your input (like > > "Heading\nSubHeading\nLine1\nLine2\n..."), then you'll have lots of > > nearly empty packets flying across your network, which creates a > > horrible performance problem for the program using > UTL_FILE, and for > > others who have to compete against the traffic. > > > > Check out the trcfiled.pl part of Sparky > > (www.hotsos.com/products/sparky). It's open source Perl > that does file > > transfers (and a few other things) on the order of 100x faster than > > UTL_FILE. It's a free download. > > > > > > Cary Millsap > > Hotsos Enterprises, Ltd. > > http://www.hotsos.com > > > > Upcoming events: > > - Hotsos Clinic 101 in Dallas, Washington, Denver, Sydney > > - Hotsos Symposium 2004, March 7-10 Dallas > > - Visit www.hotsos.com for schedule details... > > > > > > -----Original Message----- > > Dunn > > Sent: Wednesday, July 09, 2003 8:24 AM > > To: Multiple recipients of list ORACLE-L > > > > I have a problem with utl_file in Oracle 9 on Linux, standard > > engine.... > > > > It does not seem to want to read lines longer than 997 > characters. It > > works fine if the line is 997 characters or less. > > > > I get a utl_file.write_error exception if the line is > longer than 997 > > charcaters!!!!!!!!!!! Why a write error when I am reading? > > > > I have set the line size in the utl_file.FOPEN and > utl_file.read_line > > to 998 > > > > > > Is this a bug? > > > > > > original_kic_file_handle := > > utl_file.FOPEN(var_transfer_dir,var_file_name||'.KIC','r',998); > > > > > > > > utl_file.get_line(original_kic_file_handle,var_current_line,998); > > > > > > John > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: John Dunn > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web > hosting services > > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L (or the > > name of mailing list you want to be removed from). You may > also send > > the HELP command for other information (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Cary Millsap > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web > hosting services > > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L (or the > > name of mailing list you want to be removed from). You may > also send > > the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (or the name of mailing list you want to be removed > from). You may also send the HELP command for other > information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Richard Ji > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (or the name of mailing list you want to be removed > from). You may also send the HELP command for other > information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Matthew Zito INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).