Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: problem with utl_file : lines longer than 2000 char not supported!!
On Thu, 22 Oct 1998 15:58:16 +0200, "Bram Stieperaere"
<bse_at_NO_SPAMsodexho-pass.be> wrote:
>Hi all,
>
>I am trying to import a file with utl_file from within PL/SQL (Oracle 7.3)
>The problem is that lines can be up to 2048 characters long and the buffer
>parameter of utl_file.get_line is a varchar2, limited to 2000 characters.
>
>There is no way for me to alter the input file. I searched for a way to
>import the file in a (long) raw, but as far as I know no function exists to
>import a file directly into a blob field from within PL/SQL.
>
>Does anyone have experience with this?
Not only that varchar2 is limited to 2000 in Oracle7, the UTL_FILE.GET_LINE can handle only lines up to 1022 characters! I don't know of any way how to read lines longer than this limit directy from within PL/SQL. I'm affraid you'll have to preprocess the input file or to use some other tool/program.
>TIA
>
>Bram Stieperaere
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)