Mythili karanam

• Aug 9th, 2011

 

1)Create one directory in OS(Operating System)
Place all the images in this directory
2) create one directory in data base with the link of this os directory
eg:E:ordb

Create table images(img_name varchar2(30),mime_type varchar2(30),content blob);

Code
CREATE OR REPLACE PROCEDURE


Load(filename VARCHAR2)


AS


f_lob bfile; 


B-lob blob;


BEGIN


   INSERT INTO images


   VALUES(filename,SUBSTR(filename,INSTR(filename,'.')+1),EMPTY_BLOB());


RETURN content INTO b_lob;


f_lob:=BFILENAME('ordb',fielanme);


DBMS_LOB.fileopen(f_lob,DBMS_LOB.file_readonly);


DBMS_LOB.loadfromfile(b_lob,f_lob,DBMS_LOB.getlength(f_lob));


DBMS_LOB.fileclose(f_lob);


COMMIT;


END;