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

Home -> Community -> Usenet -> c.d.o.server -> Re: utl_file package help ?

Re: utl_file package help ?

From: <nmk_1970_at_hotmail.com>
Date: 1997/09/04
Message-ID: <873380865.8210@dejanews.com>#1/1

In article <340B788C.6B9EC774_at_singnet.com.sg>,   Terrence Wong <mingjun_at_singnet.com.sg> wrote:
>
> Hi,
> I have a problem.
> The utl_file.get_line procedure returns a read error when I try to
> read in a text file with one of the lines of length 1300. I think
> there is a length limit of maybe 1024 for get_line. Is that true?
> How can I solve this problem? Not a good idea to reformat my text
> file. Any help? TIA.
>
> Cheers.
> Terrence

  Yes,

    The maximum size of the input record is 1022 bytes,You cannot     read a record which has more than this limit.

    For further information Please read the Application developers     Guide by oracle.

/muralikrishna

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Thu Sep 04 1997 - 00:00:00 CDT

Original text of this message

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