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

2003-07-11 Thread Jared Still
On Wednesday 09 July 2003 09:59, Matthew Zito wrote:

 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.

Weenies.

Jared

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  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).



utl_file on Redhat Linux Oracle 9 standard engine

2003-07-09 Thread John Dunn
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).


Re: utl_file on Redhat Linux Oracle 9 standard engine

2003-07-09 Thread Tanel Poder
Hi!

Desc utl_file shows:

FUNCTION FOPEN RETURNS RECORD
 Argument Name  TypeIn/Out Default?
 -- --- -- 
   ID   BINARY_INTEGER  OUT
   DATATYPE BINARY_INTEGER  OUT
 LOCATION   VARCHAR2IN
 FILENAME   VARCHAR2IN
 OPEN_MODE  VARCHAR2IN
 MAX_LINESIZE   BINARY_INTEGER  IN DEFAULT

Starting from 8.0.5 or so the max linesize was 32767 chars, but the default
max linesize has remained same (1023)

So use FOPEN with max_linesize.

Btw, I found this answer from metalink with first search: utl_file line size

Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 4:24 PM


 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: Tanel Poder
  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).


RE: utl_file on Redhat Linux Oracle 9 standard engine

2003-07-09 Thread Cary Millsap
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).


RE: utl_file on Redhat Linux Oracle 9 standard engine

2003-07-09 Thread John Dunn
Thought I already was??? I set max_linesize to 998. I have also tried
with 32767. 

utl_file.FOPEN(var_transfer_dir,var_file_name||'.KIC','r',32767);

Still no joy

-Original Message-
Sent: 09 July 2003 14:40
To: Multiple recipients of list ORACLE-L


Hi!

Desc utl_file shows:

FUNCTION FOPEN RETURNS RECORD
 Argument Name  TypeIn/Out Default?
 -- --- -- 
   ID   BINARY_INTEGER  OUT
   DATATYPE BINARY_INTEGER  OUT
 LOCATION   VARCHAR2IN
 FILENAME   VARCHAR2IN
 OPEN_MODE  VARCHAR2IN
 MAX_LINESIZE   BINARY_INTEGER  IN DEFAULT

Starting from 8.0.5 or so the max linesize was 32767 chars, but the default
max linesize has remained same (1023)

So use FOPEN with max_linesize.

Btw, I found this answer from metalink with first search: utl_file line size

Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 4:24 PM


 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: Tanel Poder
  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: 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).


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

2003-07-09 Thread rgaffuri
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).


Re: utl_file on Redhat Linux Oracle 9 standard engine

2003-07-09 Thread Tanel Poder
Hi!

Actually I read your post more thorougly, it seems that you have specified
max linesize already.
But this var_current_line, how is this one defined? If it's reduce it's size
to varchar2 (to 998) as well.

Tanel.

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 4:24 PM


 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: Tanel Poder
  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).


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

2003-07-09 Thread Richard Ji
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).


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

2003-07-09 Thread Matthew Zito

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