You can't write to a BFILE. You could write a java stored procedure that
wrote a lob out to a bfile. So you could put the image in a temporary lob
and have the java stored proc write it out to the file system.
Jim
"Brian Tkatch" <brian.tkatch_at_shopsforme.com> wrote in message
news:1a80lugpsgv4q19be719tbq94p6v5cqit1_at_4ax.com...
> Currently, there is a some OCI code that INSERTs records into a table.
> We now want to add images to be stored with the records as a BFILE.
> The images are to be stored on the same server as Oracle, which is not
> local. But the OCI code is run from a separate local server.
>
> The question is, how to get the images rfom the local server to the
> non-local server. Could we do it through Oracle, or is some other
> procedure such as FTP required?
>
> Brian
Received on Tue Aug 06 2002 - 19:11:31 CDT
