Re: utl_file limit of 1023 byte. How avoid it?

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Fri, 08 Jan 1999 00:17:25 GMT
Message-ID: <36984d54.29177284@inet16.us.oracle.com>

On Thu, 07 Jan 1999 22:17:36 GMT, fn032944_at_flashnet.it wrote:

>HI,
>I have to write to a file line of 2000 byte. I use utl_file but the
>limit of 1023 per line makes me problem.
>How could avoid it?
>tia
>Max from Rome

In versions before 8i, there is no other way but to split it up.

But in 8i, the utl_file.fopen function has been extended to

   allow for a max_linesize up to 32K.

from the 8i utl_file spec...

<quote>

  /*
  ** FOPEN - open file (user-specified maximum line size)
  **
  ** This version of FOPEN allows the user to specify the desired

maximum

• line size. The version with the default line size is earlier in this
• package, for compatibility reasons. **
• IN
• location - directory location of file
• filename - file name (including extention)
• open_mode - open mode ('r', 'w', 'a')
• max_linesize - maximum number of characters per line, including the
• newline character, for this file.
• (minimum value 1, maximum value 32767)
• RETURN
• file_type handle to open file
• EXCEPTIONS
• invalid_path - file location or name was invalid
• invalid_mode - the open_mode string was invalid
• invalid_operation - file could not be opened as requested
• invalid_maxlinesize - specified max_linesize is too large or too small */ FUNCTION fopen(location IN VARCHAR2, filename IN VARCHAR2, open_mode IN VARCHAR2, max_linesize IN BINARY_INTEGER) RETURN file_type; </quote>

hope this helps

chris.

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jan 07 1999 - 18:17:25 CST