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