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
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
Hi!
Desc utl_file shows:
FUNCTION FOPEN RETURNS RECORD
Argument Name TypeIn/Out Default?
-- --- --
ID BINARY_INTEGER OUT
DATATYPE
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
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:
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
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
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
] 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