xml图片列插入到 oracle 数据库中

Question

我插入的时候 提示我 ORA-01704: string literal too long  但是我对应的是 blob 字段啊 有的朦胧 求高手指教

Answer 1

为什么不是插入到xmltype字段?

Answer 2

在数据库中 保存 图片的 不是 blob 类型么 ......我的XML 中有很多列 但是就是在插入 二进制流的时候 插入失败 请问我要怎么弄啊...... 或者大家 有什么 方法 可以 让小弟看看么

Answer 3

我们一般是把图片做base64编码,然后用xml传进来.前台读取的时候做解码

Answer 4

我的图片也是用的base64编码 哥们能给点代码提示么好么 

Answer 5

别人前台组成xml,然后通过存储过程的xmltype参数传进来,我只解析并存储

Answer 6

  SELECT COUNT(*)
    INTO v_num
    FROM TABLE(xmlsequence(extract((SELECT orderdata
                                     FROM frame_flow_order
                                    WHERE orderid = i_orderid),
                                   '/orderData/entity/appPhoto/frameResPhoto[*]')));
  --提取相关参数,调用添加过程.
  FOR i IN 1 .. v_num LOOP
    v_sql := 'select extractvalue(t.orderdata,''/orderData/entity/appPhoto/frameResPhoto[' || i ||
             ']/resuri''),extractvalue(t.orderdata,''/orderData/entity/appPhoto/frameResPhoto[' || i ||
             ']/restype''),extractvalue(t.orderdata,''/orderData/entity/appPhoto/frameResPhoto[' || i ||
             ']/filename''),extractvalue(t.orderdata,''/orderData/entity/appPhoto/frameResPhoto[' || i ||
             ']/photo''),extractvalue(t.orderdata,''/orderData/entity/appPhoto/frameResPhoto[' || i ||
             ']/psize''),extractvalue(t.orderdata,''/orderData/entity/appPhoto/frameResPhoto[' || i ||
             ']/phototype''),extractvalue(t.orderdata,''/orderData/entity/appPhoto/frameResPhoto[' || i ||
             ']/photoext''),extractvalue(t.orderdata,''/orderData/entity/appPhoto/frameResPhoto[' || i ||
             ']/sortno''),extractvalue(t.orderdata,''/orderData/entity/appPhoto/frameResPhoto[' || i ||
             ']/creatorid'') from frame_flow_order t where t.orderid=''' ||
             i_orderid || '''';
    BEGIN
      EXECUTE IMMEDIATE v_sql
        INTO v_resuri, v_restype, v_filename, v_photo, v_psize, v_phototype, v_photoext, v_sortno, v_creatorid;
    EXCEPTION
      WHEN OTHERS THEN
        o_dealstats   := 0;
        o_dealmessage := '工单信息有误';
        GOTO photo_back; --跳转至本环节回滚处
    END;没用dom解析,直接用xmlpath提取的.