Mongol IT: Insert image as BLOB into DB using stored procedure.
You need first to declare your package : CREATE OR REPLACE PACKAGE IMAGE ASPROCEDURE load(filename VARCHAR2);PROCEDURE get(name varchar2);end;/ then you specify your package CREATE OR REPLACE PACKAGE BODY IMAGE AS PROCEDURE load(filename VARCHAR2) ASf_lob BFILE;b_lob BLOB;image_name VARCHAR2(30);mime_type VARCHAR2(30);dot_pos NUMBER;BEGINdot_pos := INSTR(filename,’.’);image_name := filename; –SUBSTR(filename,1,dot_pos-1);mime_type := ‘image/’||SUBSTR( filename,dot_pos 1,length(filename) ); INSERT INTO images values(image_name,mime_type,empty_blob() )RETURN contentRead More