1 11:26:13 SQL Prepare: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =263201 order by RCKMXH 2 11:26:13 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =263201 order by RCKMXH 3 11:26:14 SQL Prepare: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =264101 order by RCKMXH 4 11:26:14 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =264101 order by RCKMXH 5 11:26:14 SQL Prepare: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 in +264101order by RCKMXH 6 11:26:14 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 in +264101order by RCKMXH 7 11:26:17 SQL Prepare: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 in +264101order by RCKMXH 8 11:26:17 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 in +264101order by RCKMXH 9 11:26:18 SQL Prepare: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =264101 order by RCKMXH 10 11:26:18 SQL Execute: ORACLE - select a.RCKMXH,a.RCKID0,a.KCID00, a.FPH000,a.FPRQ00,a.WZDMID,a.WZMC00,a.WZSXMC,a.WZID00, a.CJMC00,a.CJID00,a.GJMC00,a.GGXH00,a.GG0000,a.PH0000,a.YXQ000,a.WZXH00,a.SXRQ00,a.BZSL00 CRKSL0,a.WZDW00, a.CGJBZ0 CGJ000,a.CKPFJ0,a.KL0000,a.CRCJ00,a.CXBZ00,a.CXMXID,a.ZJE000,a.JCS000,b.BZDW00,a.WZLBMC from VW_WZ_RCKMX0 a,WZ_WZXX00 b WHERE a.WZID00=b.WZID00 AND RCKID0 =264101 order by RCKMXH 11 11:26:18 SQL Prepare: ORACLE - Select COUNT(DISTINCT FPH000) as FPZS00 from WZ_RCKMX0 Where FPH000 is not null and rckid0 in (264101) 12 11:26:18 SQL Execute: ORACLE - Select COUNT(DISTINCT FPH000) as FPZS00 from WZ_RCKMX0 Where FPH000 is not null and rckid0 in (264101) 13 11:26:18 SQL Prepare: ORACLE - Select SUM(ZJE000) as HJJE00 from WZ_RCKMX0 Where rckid0 in (264101) 14 11:26:18 SQL Execute: ORACLE - Select SUM(ZJE000) as HJJE00 from WZ_RCKMX0 Where rckid0 in (264101) 15 11:26:19 SQL Prepare: ORACLE - SELECT WZSXMC,WZEJFL,sum(ZJE000) ZJE000 FROM VW_WZ_RCKMX0 WHERE RCKID0 in (264101) group by WZSXMC,WZEJFL 16 11:26:19 SQL Execute: ORACLE - SELECT WZSXMC,WZEJFL,sum(ZJE000) ZJE000 FROM VW_WZ_RCKMX0 WHERE RCKID0 in (264101) group by WZSXMC,WZEJFL 17 11:26:19 SQL Prepare: ORACLE - select (select SP_WZ_RCKDH0_TJ() from dual) FKDHZ0,'其中：其他材料(办公用品类:32000.00)' HKSY00,'叁万贰仟元整' RMBDX0,'32000.00' RMBXX0,1 FPZS00, FKDH00,FHBMMC DWQC00,substr(a.KDRQ00,1,4)||'年'||substr(a.KDRQ00,5,2)||'月'||substr(a.KDRQ00,7,2)||'日' ZWKDRQ, substr(a.QRRQ00,1,4)||'年'||substr(a.QRRQ00,5,2)||'月'||substr(a.QRRQ00,7,2)||'日' ZWQRRQ,substr(a.SHRQ00,1,4)||'年'||substr(a.SHRQ00,5,2)||'月'||substr(a.SHRQ00,7,2)||'日' ZWSHRQ,a.* from vw_wz_RCK000 a where rckid0 in (264101) and rownum=1 18 11:26:19 SQL Execute: ORACLE - select (select SP_WZ_RCKDH0_TJ() from dual) FKDHZ0,'其中：其他材料(办公用品类:32000.00)' HKSY00,'叁万贰仟元整' RMBDX0,'32000.00' RMBXX0,1 FPZS00, FKDH00,FHBMMC DWQC00,substr(a.KDRQ00,1,4)||'年'||substr(a.KDRQ00,5,2)||'月'||substr(a.KDRQ00,7,2)||'日' ZWKDRQ, substr(a.QRRQ00,1,4)||'年'||substr(a.QRRQ00,5,2)||'月'||substr(a.QRRQ00,7,2)||'日' ZWQRRQ,substr(a.SHRQ00,1,4)||'年'||substr(a.SHRQ00,5,2)||'月'||substr(a.SHRQ00,7,2)||'日' ZWSHRQ,a.* from vw_wz_RCK000 a where rckid0 in (264101) and rownum=1 19 11:26:20 SQL Error: ORACLE - ORA-06553: PLS-306: 调用 'SP_WZ_RCKDH0_TJ' 时参数数量或类型错误 20 11:26:20 SQL Error: ORACLE - Unmapped SQL Error Code: 6553 21 11:26:20 SQL Data In: ORACLE - Rows affected = 0