How to upload file with oracle database 10gR2??
i can't find how to upload..
i've tried to create a procedure in oracle and execute in netbeans but the file save in directory and then from directory save to database.
it means the file save in 2 location, in directory and database..
does anybody know how to save file direct from the JSP file into database without save in directory?

this is the procedure..

Code:
create or replace PROCEDURE load_file ( 
p_id number, 
p_photo_name in varchar2) IS 

src_file BFILE; 
dst_file BLOB; 
lgh_file BINARY_INTEGER; 

BEGIN 
src_file := bfilename('DIR_TEMP', p_photo_name); 

-- insert a NULL record to lock 
INSERT INTO temp_photo 
(id, photo_name, photo) 
VALUES 
(p_id , p_photo_name ,EMPTY_BLOB()) 
RETURNING photo INTO dst_file; 

-- lock record 
SELECT photo 
INTO dst_file 
FROM temp_photo 
WHERE id = p_id 
AND photo_name = p_photo_name 
FOR UPDATE; 

-- open the file 
dbms_lob.fileopen(src_file, dbms_lob.file_readonly); 

-- determine length 
lgh_file := dbms_lob.getlength(src_file); 

-- read the file 
dbms_lob.loadfromfile(dst_file, src_file, lgh_file); 

-- update the blob field 
UPDATE temp_photo 
SET photo = dst_file 
WHERE id = p_id 
AND photo_name = p_photo_name; 

-- close file 
dbms_lob.fileclose(src_file); 
END load_file;

Last edited by shabbir; 31Mar2011 at 09:58.. Reason: Code blocks