批量插入带BLOB的数据

  源端插数据：
//创建一个目录在oracle中，指定'/opt/images'将图片'21k.BMP'放到这个目录下
    CREATE   OR   REPLACE   DIRECTORY   "images"   AS   '/opt/images';  

  declare 
    F_BLOB BFILE:= BFILENAME ('images','21k.BMP'); 
    B_BLOB BLOB:=EMPTY_BLOB ();
    BEGIN
    FOR V_count IN 1..500000 Loop
    DBMS_LOB.FILEOPEN (F_BLOB, DBMS_LOB.FILE_READONLY); 
    INSERT INto 优化_表1 VALUES(v_count,1,'C_SF',v_count||0.18,'从不会','从不见的问',1,'次的进入','从小的会公司提','ZTLX','C_SJJZD','JKZK','从他把他们投资','从他是他们平','HYZK',2,'C_LXRXX从联系人信息','C_XDHGSH从现代化工商','C_BZ备注',1234,'C_XM此项目',v_count,sysdate,sysdate,'C_XDHGJT',v_count,3,'C_HJPCS和精品才是','C_CH×','C_SHDW','C_SJPCS才是经批次是','C_FLWSBH发了我是不会','C_QTZJHM其他自己还没','C_GJ','C_CCBZ','C_MZ','C_GXXZ从各项选择','C_DWDM',12,sysdate,'CCS',3,'C_BRLXFS本人类型是','C_HJSZDXZ','C_GXSQ个性是全','C_HJSZD',1,sysdate,'C_RYLX','C_ACTION','C_FWCS分为参赛','C_CHDQ','C_XB','C_XGBSDW','WHCD',sysdate,'C_BJDWXC不见的文学参','C_PINYIN品饮','1234','C_YDWDM',v_count,'C_SJJZDXZ是经济作的现在','C_XSDPZL下是的品资料','C_XZ','C_ZSDPZL在是的品资料','C_MJLXDH目经理系电话','C_SFZHM',sysdate,sysdate,'CG和国','C_CXDW从小的问','C_ZRMJ在人民间','C_BJMJ不见面积',v_count,v_count,v_count||0.28,'1','使用位编码','审编码','制作单位编码','01','01','印油说明','经办人','330721198301010101','审批人','12-27','12-27','12-27','12-27','12-27','12-27',sysdate,'12-27','400','200','5','2','45×6',EMPTY_BLOB())RETURN t_Blob INTO B_BLOB;
    INSERT INTO 优化_表2 VALUES(v_count,'印章名称','1','使用位编码','审编码','制作单位编码','01','01','印油说明','经办人','330721198301010101','审批人','12-27','12-27','12-27','12-27','12-27','12-27','12-27','12-27','400','200','5','2','45×6');
    DBMS_LOB.LOADFROMFILE (B_BLOB, F_BLOB, DBMS_LOB.GETLENGTH (F_BLOB)); 
    commit;
    end Loop;
    DBMS_LOB.FILECLOSE (F_BLOB); 
    end;