1       15:18:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 369
2       15:18:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = LX
3       15:18:29  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL
4       15:18:29  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGXG
5       15:18:29  SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ?  and YQDH00 = ?  AND QXLX00 = ?  and QXGNDH = ? 

6       15:18:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 369
7       15:18:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = LX
8       15:18:29  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL
9       15:18:29  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JMXZ
10      15:18:29  SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ?  and YQDH00 = ?  AND QXLX00 = ?  and QXGNDH = ? 

11      15:18:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = LX
12      15:18:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200316
13      15:18:29  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200316
14      15:18:29  SQL Execute: ORACLE -  select rownum RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,YEXM00,ZYHGHH,MZZYBZ,YXBZ00,SECTOR,    CUPNUM,JYKDY0,decode(MZZYBZ||SFTJ00,'0Y','体','0N','门','住') MZZY00 ,    SF_JY_GETJGZTMC(YBH000,PYRQ00,JGZT00) JGZTMC,SFTJ00,JGZT00,SFCJJZ,YJTS00,TXM000  from ( select distinct YBH000,PYRQ00,to_char(to_date(PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01, BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,    YEXM00,ZYHGHH,MZZYBZ,SF_JY_GETYBHJZBZ(YBH000,PYRQ00) YXBZ00,    (select sum(distinct(SECTOR)) from JY_JYJG00_TEMP where PYRQ00=Y.PYRQ00 and YBH000=Y.YBH000) SECTOR,    (select sum(distinct(CUPNUM)) from JY_JYJG00_TEMP where PYRQ00=Y.PYRQ00 and YBH000=Y.YBH000) CUPNUM,    (select nvl(JYKDY0,'N') from TJ_BRXXB0 where GHID00=Y.ZYGHID) JYKDY0,JGZT00,SFTJ00,    decode((select SF_JUDGE_RESULT_JZ(Y.PYRQ00,Y.YBH000,Y.JGZT00) from dual),0,'N','Y') SFCJJZ,    (select decode(count(1),0,'0','1') from JY_JYJG00_TEMP     where JYJG00 is not null and YBH000=Y.YBH000 and PYRQ00=Y.PYRQ00) SFCJG0, TXM000,    SF_JY_GETTATYJTS(BBCYRQ,BBCYSJ,HGSDRQ,HGSDSJ,HGSCRQ,HGSCSJ,BBSDRQ,BBSDSJ,                     MZZYBZ,SFTJ00,JGZT00,YXBZ00,ZLXMID,SF_JY_JYTERM(JGZT00,'1'),0.5,0.1) YJTS00  from VW_JY_YW0000 Y  where YBH000 like (? ||'%')  and (PYRQ00 between decode('N','Y',to_char(sysdate-180,'YYYYMMDDD'),?) and decode('N','Y',to_char(sysdate,'YYYYMMDDD'),?))  and JGZT00||'A' in ('4A') 
       order by YBH000) 

15      15:18:29  SQL Error: ORACLE - ORA-06553: PLS-306: 调用 'SF_JY_JYTERM' 时参数个数或类型错误

16      15:18:29  SQL Error: ORACLE - Unmapped SQL Error Code: 6553
17      15:18:29  SQL Data In: ORACLE - Rows affected = 0