Re: writing blob to file on disk in pl/sql server

[Quoted] There's a free package called UTL_BINFILE (plus some supporting Java), which comes with our PSP_Mail product (worth looking at by itself ;) - it handles all aspects of reading/writing/listing binary files. Requires JServer/Oracle VM, but does not require you to create any external procedures and is much more portable thanks to Java. You are free to rip it off PSP_Mail and use whereever you want/need. Package is fully documented in PSP_Mail User's Guide (read through it as it also covers Java security issues you will undoubtly face - OS files access is subject to strict permission control). Note that Java source code for this package is *NOT* available, only compiled .jar file.

hth.

-- 
Vladimir Zakharychev (bob_at_dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"PS" <pski_at_wp.pl> wrote in message news:c6222d2.0204030252.55af84b0_at_posting.google.com...


> i would like to write blob into file in pl/sql. I know how to get a


> file from blob but i don't know how to write it as a file in PL/SQL.

> Is it possible?