Error [Oracle Error 06502: PL/SQL: numeric or value error] in report method [CUSTOMER_ORDER_COLL_IVC_RPI.Report_Collective_Invoice] ORA-20105: Report.REPRUNERR
问题原因:出货资料的批号太多,字节数超个2000
问题解决:
1) -- Add/modify columns
alter table ORDER_INFO_SERVICES_RPT modify S51 VARCHAR2(4000);
2) Modify CUSTOMER_ORDER_COLL_IVC_RPI.Report_Collective_Invoice
lot_batch_nos_ VARCHAR2(2000);
==> lot_batch_nos_ VARCHAR2(4000);