| Author |
Working with Oracle BFiles...
|
Franck Tranchant
Ranch Hand
Joined: Aug 07, 2003
Posts: 75
|
|
Hi, Did someone here already tried to develop something based on Oracle's BFILE (used to store a locator to a file outside the database, stored somewhere on the filesystem of the data server) ? I found some basic infos on Advanced JDBC Samples @ Technet.oracle.com but all samples seem to use that kind of query : INSERT INTO BFILE_TABLE VALUES (BFILENAME('BFILEDIR', 'myFile.gif')) In this case, myFile.gif need to reside in the server in which database is running So, I wonder if it's possible to manipulate Streams instead of files stored on the Database server... Basically, I would like allow a user to upload a file from his Internet Explorer to the Database. Do you think the 3 following steps are required ? 1- Upload from Client side to Server Side (WebLogic) 2- Upload from Server Side to Database Side (Oracle) 3- Execute the Insert query Any info is welcome
|
Franck<p>--------------------
|
 |
 |
|
|
subject: Working with Oracle BFiles...
|
|
|