Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!in.100proofnews.com!in.100proofnews.com!irazu.switch.ch!switch.ch!news.bme.hu!news.matavnet.hu!newsfeed.matavnet.hu!image.surnet.ru!not-for-mail From: "Igor Shulgin" Newsgroups: comp.databases.oracle.misc Subject: Writing binary data to external file Date: Fri, 8 Aug 2003 16:35:05 +0600 Organization: South Ural Network Lines: 18 Message-ID: NNTP-Posting-Host: nexus.chelptt.ru X-Trace: image.surnet.ru 1060338906 26484 212.57.144.30 (8 Aug 2003 10:35:06 GMT) X-Complaints-To: abuse@surnet.ru NNTP-Posting-Date: Fri, 8 Aug 2003 10:35:06 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:130360 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