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: <Andreas.Haunschmidt_at_voestalpine.com>
Date: Fri, 21 Mar 2003 16:52:09 +0100
Message-Id: <24738.322709@fatcity.com>


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-----
From: Jeroen van Sluisdam [mailto:jeroen.van.sluisdam_at_vrijuit.nl] Sent: Thursday, March 20, 2003 5:09 PM
To: Multiple recipients of list ORACLE-L Subject: utl_file.put error

[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).
Received on Fri Mar 21 2003 - 09:52:09 CST

Original text of this message

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