ããä¾ï¼å设ç»oracleæ°æ®åºå¯¼å
¥blobç±»åçå¾çï¼å¾çæ¾å¨ç®å½G:\imagesä¸ã 1.å
å建ä¸ä¸ªç®å½directoryï¼å½å为IMAGESï¼ CREATE OR REPLACE DIREï¼TORY IMAGES AS 'G:\test';æè
ç´æ¥å¨PlSql Directoriesç®å½ä¸æ°å»ºç®å½ï¼ 2.å建ä¸ä¸ªåå¨è¿ç¨ï¼æ¹é导å
¥blob create or replace procedure img_insert asbeginDECLARE f_lob bfile;--æ件类åb_lobblob; --ç¨æ¥åå¨å¾ççå称filenamevarchar2(400);begin --循ç¯çåå§å¼for i in 1 .. 100 loop --æ¾åºæ¯ä¸åçæ件åï¼å 为æ件ååå¾çå称æ¯ä¸æ ·ç select t.flnm into filename from ZS_GC_SNIMDT t where t.id =i; --æ¥æ¾å°ä¹åï¼æ§è¡updateæä½,æå
¥ç©ºçblob ï¼æ³¨æIMAGESä¸å®è¦å¤§åï¼ update ZS_GC_SNIMDT set brfl = empty_blob()whereid = i return brfl into b_lob; --è·åæå®ç®å½ä¸çæ件 f_lob := bfilename('IMAGES', filename); -- 以åªè¯»çæ¹å¼æå¼æ件 dbms_lob.fileopen(f_lob, dbms_lob.file_readonly);--ä¼ é对象 dbms_lob.loadfromfile(b_lob, f_lob, dbms_lob.getlength(f_lob)); --å
³éåå§æ件
温馨提示:答案为网友推荐,仅供参考