我要生成数据到execl 但我觉得ORACLE貌似有限制,列数太多就生成不了了,不知道为什么
如果把注释部分打开就无法生成EXCEL了,感觉受到了限制,不知道怎么取消限制
create or replace procedure inventoryReportMainland_static is
  xls_file  utl_file.file_type;
  dir_name  varchar2(30) := 'TEST_DIR';
  file_name varchar2(100) := 'temp_excel.xls';begin
  xls_file := utl_file.fopen(dir_name, file_name, 'W');
  utl_file.put(xls_file, 'CATEGORY_NM' || chr(9));
  utl_file.put(xls_file, 'NEW_CATEGORY' || chr(9));
  utl_file.put(xls_file, 'GCODE' || chr(9));
  utl_file.put(xls_file, 'ITEM_CODE' || chr(9));
  utl_file.put(xls_file, 'ITEMNAME' || chr(9));
  utl_file.put(xls_file, 'FRGNNAME' || chr(9));
  utl_file.put(xls_file, 'VINTAGE' || chr(9));
  utl_file.put(xls_file, '1.SHWGWH' || chr(9));
  utl_file.put(xls_file, '5.GZFunction:return notsell' || chr(9));
  utl_file.put(xls_file, '3.CDFunction:return notsell' || chr(9));
  utl_file.put(xls_file, '3.CDFunction:BAD' || chr(9));
  utl_file.put(xls_file, '3.CDBooking' || chr(9));
  utl_file.put(xls_file, '1.SHFunction:SHIC' || chr(9));
  utl_file.put(xls_file, '1.SHWGWHFuction:' || chr(9));
  utl_file.put(xls_file, '1.SHWGFunction:BAD' || chr(9));
  utl_file.put(xls_file, '1.SHWH_ReceiveTemp' || chr(9));
  utl_file.put(xls_file, '3.CDFunction:V' || chr(9));
  utl_file.put(xls_file, '2.BJFunction:BAD' || chr(9));
  utl_file.put(xls_file, '4.SZWH' || chr(9));
  utl_file.put(xls_file, '6.XMBooking' || chr(9));
  utl_file.put(xls_file, '6.ToXM' || chr(9));
  utl_file.put(xls_file, '1.SHFunction:internal notsell' || chr(9));
  utl_file.put(xls_file, '1.SHWH' || chr(9));
  utl_file.put(xls_file, '3.CDFunction:internal notsell' || chr(9));
  utl_file.put(xls_file, '2.BJWH_ReceiveTemp' || chr(9));
  utl_file.put(xls_file, '5.GZBooking' || chr(9));
  utl_file.put(xls_file, 'To-11201' || chr(9));
  utl_file.put(xls_file, '6.XMFunction:BAD' || chr(9));
  utl_file.put(xls_file, '1.SHWG' || chr(9));
  utl_file.put(xls_file, '2.BJWH' || chr(9));
  utl_file.put(xls_file, '1.SHFunction:BAD' || chr(9));
  utl_file.put(xls_file, '3.ToCD' || chr(9));
  utl_file.put(xls_file, '1.SHFunction:' || chr(9));
  utl_file.put(xls_file, '5.GZFunction:internal notsell' || chr(9));
  utl_file.put(xls_file, '1.SHWGFunction:return notsell' || chr(9));
  utl_file.put(xls_file, '4.SZFunction:BAD' || chr(9));
  utl_file.put(xls_file, '1.SHWGFunction:internal notsel' || chr(9));
  utl_file.put(xls_file, '3.CDFunction:F-SHWH' || chr(9));
  utl_file.put(xls_file, '5.ToGZ' || chr(9));
  utl_file.put(xls_file, '3.CDWH_ReceiveTemp' || chr(9));
  utl_file.put(xls_file, '5.GZFunction:IC' || chr(9));
  utl_file.put(xls_file, 'BTLR' || chr(9));
  utl_file.put(xls_file, '2.BJFunction:return notsell' || chr(9));
  utl_file.put(xls_file, '1.SHBooking' || chr(9));
  utl_file.put(xls_file, '2.ToBJ' || chr(9));
  utl_file.put(xls_file, '2.BJFunction:internal notsell' || chr(9));
  utl_file.put(xls_file, '3.CDWH_ReturnTemp' || chr(9));
  utl_file.put(xls_file, '1.ToSH' || chr(9));
  utl_file.put(xls_file, '2.BJWG' || chr(9));
  utl_file.put(xls_file, '2.BJFunction:' || chr(9));
  utl_file.put(xls_file, '3.CDWH' || chr(9));
  utl_file.put(xls_file, '1.SHFunction:V' || chr(9));
  utl_file.put(xls_file, '1.SHWH_ReturnTemp' || chr(9));
  utl_file.put(xls_file, '2.BJFunction:V' || chr(9));
  utl_file.put(xls_file, '1.SHFunction:IC' || chr(9));
  utl_file.put(xls_file, '1.ToSHWG' || chr(9));
  utl_file.put(xls_file, '1.SHWG_ReturnTemp' || chr(9));
  utl_file.put(xls_file, '6.XMWH_ReceiveTemp' || chr(9));
  utl_file.put(xls_file, '1.SHWGFunction:V' || chr(9));
  utl_file.put(xls_file, '5.GZWH' || chr(9));
  utl_file.put(xls_file, '1.SHBond' || chr(9));
  utl_file.put(xls_file, '5.GZWH_ReturnTemp' || chr(9));
  utl_file.put(xls_file, '2.BJWH_ReturnTemp' || chr(9));
  utl_file.put(xls_file, '1.SHFunction:return_notsell' || chr(9));
 utl_file.put(xls_file, '1.SHCC' || chr(9));
   utl_file.put(xls_file, '5.GZFunction:BAD' || chr(9));
  utl_file.put(xls_file, '6.XMWH' || chr(9));
  /*utl_file.put(xls_file, '2.BJBooking' || chr(9));
  utl_file.put(xls_file, 'Purchase QTY' || chr(9));
  utl_file.put(xls_file, 'Grand Total' || chr(9));*/  utl_file.put_line(xls_file, '');
  utl_file.fclose(xls_file);end inventoryReportMainland_static;