Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: utl_file.put error

RE: utl_file.put error

From: Jeroen van Sluisdam <jeroen.van.sluisdam_at_vrijuit.nl>
Date: Mon, 24 Mar 2003 09:44:40 +0100
Message-Id: <24756.322838@fatcity.com>


When I have for example a long variable with lengths between 1000 and 3500 chars
and I write with use of utl_file.put I can process lots of rows succesfully and
then I get write error.

Are you suggesting the 1023 limit is a global setting that is also applicable for utl_file.put ?

Details: oracle 7.3.4 hp-ux 10.20 (cannot change the limit like in oracle 8)

Tia,

Jeroen

-----Oorspronkelijk bericht-----
Van: Andreas.Haunschmidt_at_voestalpine.com [mailto:Andreas.Haunschmidt_at_voestalpine.com] Verzonden: vrijdag 21 maart 2003 16:54
Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: utl_file.put error

The default maximum number of characters per line for UTL_FILE.FOPEN is 1023.
When using repeatedly UTL_FILE.PUTS, it appends characters to the current output line, Oracle counts the the total number of characters per line written, and it seems, your program exceeded this maximum.

Either issue a UTL_FILE.PUT_LINE before you reach this limit,
(this will start a new line and reset our imaginary internal character
counter)
or use an overloaded UTIL_FILE.FOPEN version, which allows you to set the maximum number of characters per line explicitly.

Excerpt from oracle documentation:

 UTL_FILE.FOPEN (
   location IN VARCHAR2,
   filename IN VARCHAR2,
   open_mode IN VARCHAR2,
   max_linesize IN BINARY_INTEGER -- up to 32767 characters per line
(including the new line character)

 );

HTH   Andreas

-----Original Message-----
Sent: Thursday, March 20, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L

[BUG:458336] <ml2_documents.showDocument?p_id=458336&p_database_id=BUG> UTL_FILE.WRITE_ERROR RAISED DOING MULTIPLE PUTS OF <1023 CHARS EACH (TOTAL>1023)
[BUG:385936] <ml2_documents.showDocument?p_id=385936&p_database_id=BUG> UTL_FILE.PUT WITH BUFFER > 1023 CHARACTERS CAUSES ERROR I'm not able to read these bugreports in metalink, anybody familiar with these problems?
Details: Oracle 7.3.4 HP-UX 10.20

Tia,

Jeroen

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeroen van Sluisdam
  INET: jeroen.van.sluisdam_at_vrijuit.nl

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: ListGuru_at_fatcity.com (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: INET: Andreas.Haunschmidt_at_voestalpine.com 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: ListGuru_at_fatcity.com (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
Received on Mon Mar 24 2003 - 02:44:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US