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

Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE - how to write > 1KB to OS file without line terminator ?

Re: UTL_FILE - how to write > 1KB to OS file without line terminator ?

From: aid <aid_at_grant.kharkov.ua>
Date: Tue, 30 Nov 1999 11:01:49 +0200
Message-ID: <820cpg$acu@grant.grant.UUCP>


Igor Oussoltsev <uwd_at_uwd.baltnet.ru> wrote in message news:3842faf7_at_news.baltnet.ru...
 [skipped]
> Hi All's!
> My problem is following:
> I try to put set of characters from DB table (Oracle 8.0.5/Windows NT
> 4.0+SP3)
> to OS file.
> - if count > 1024 bytes - I get exception UTL_FILE.WRITE_ERROR !
>I'm using UTL_FILE.PUT because I must get file without line separators.
> May be UTL_FILE package has limit for length of line ???
Yes, it has. If Your file can have an arbitrary length, it's better to remove line separators by OS means.



Alexander I. Doroshko, Bank "Grant", Kharkov, Ukraine aid_at_grant.kharkov.ua Received on Tue Nov 30 1999 - 03:01:49 CST

Original text of this message

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