> The only situation I can think where bfile might be useful is if you > don't want to use a blob, but want the database to be able to pull out the > object in a database query. At least that is my understanding from a quick > reading of the documentation. > > Dennis Williams Dennis, Though I haven't tried it, I don't think that a bfile is necessary for that either. You could just code it all in java if you had some need to, and just store the file location as you stated. This does complicated backups and data integrity somewhat... Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------