Mark D Powell wrote:
> "Igor Shulgin" <igor.shulgin_at_chelptt.ru> wrote in message news:<bh7ab1$11gn$1_at_image.surnet.ru>...
>
>>Hi!
>>
>> What is standard and direct way (within Oracle 9.2 stored procedures)
>>for
>>writing binary data from Oracle to external file on disk?
>> We have tried to use UTL_FILE package, but it operates on files
>>consisting out of "line" of size no more than 32767 bytes and adds new_line
>>symbol upon closing files.
>> Also we checked out interMedia types and packages for writing BLOB to
>>disk but now we get stuck with some strange error messages.
>
>
> Igor, are you using put_raw to perform the write operation?
>
> There is no need to cross-post.
>
> HTH -- Mark D Powell --
afaicr, Tom Kyte stated that the 32k is a utl_file boundary.
You will have to use another program, or the LOB packages,
as you suggested. Without the actual errors, no dice
--
Regards, Frank van Bortel
Received on Mon Aug 18 2003 - 15:03:05 CDT
