Writing binary data to external file

    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.

--

                       With best wishes,
                                                       Igor Shulgin


---------------------------------------------------------------------------