Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE - how to write > 1KB to OS file without line terminator ?
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.
![]() |
![]() |