Upload file in JSP with Oracle Database 10gR2

Discussion in 'JSP' started by blueangel, Mar 31, 2011.

  1. blueangel

    blueangel New Member

    Joined:
    Mar 31, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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 a moderator: Mar 31, 2011

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice