RE: RE: utl_file on Redhat Linux Oracle 9 standard engine

From: Matthew Zito <mzito_at_gridapp.com>
Date: Wed, 09 Jul 2003 09:05:47 -0700
Message-ID: <F001.005C4157.20030709085930@fatcity.com>

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).

Received on Wed Jul 09 2003 - 11:05:47 CDT