I am currently working on the development for a project which
needs to store a lot of large (BINARY) files in an Oracle8 database.
It is reasonably simple to get the files in using DBMS_LOB.LoadFromFile.
Getting them back out to the file system isn't so easy. There is no
equivelent
function such as DBMS_LOB.WriteToFile and the UTL_FILE package does
not support binary files. Using BFILEs was considered but we need to be able
to transfer the database across file systems without having to worry about
copying
lots of files aswell.
Any help would be greatly appreciated.
Received on Tue Feb 03 1998 - 00:00:00 CST
