Re: Writing binary data to external file

Originally posted by Igor Shulgin
> Hi!
>
> What is standard and direct way (within Oracle 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.
>
> --
> With best wishes,
> Igor Shulgin
> -------------------------------------------------------
> --------------------
> ------
> JSC Uralsvyazinform | Applied Systems Department

Oracle version?
You can use java cartridge.

Check out this url http://www.dpsp-yes.com/dpsp/prod/!go?id_=ndownloads and look at utl_binfile.

URL may wrap.

Regards
/Rauf Sarwar

--
Posted via http://dbforums.com