1       16:58:50  SQL Execute: ORACLE - select count(1) from (select a.MZZYBZ,a.SFTJ00,a.zlxmid,a.jgzt00,a.BBCYRQ,a.BBCYSJ,a.BBSDRQ,a.BBSDSJ,a.PYRQ00,a.PYSJ00,SF_JY_GETTATZZSJ(BBCYRQ,BBCYSJ,BBSDRQ,BBSDSJ,PYRQ00,PYSJ00,MZZYBZ,SFTJ00,JGZT00,zlxmid)SFCTAT from JY_YW0000 a  where a.cbgrq0 is null and a.JGZT00||'A' in ('1A','2A','4A','5A') and a.BBCYRQ between '20170213' and '20170214')t where t.SFCTAT ='Y' 

2       16:58:50  SQL Data In: ORACLE - Param = 1, Name = PKSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170214
3       16:58:50  SQL Data In: ORACLE - Param = 2, Name = PJSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170214
4       16:58:50  SQL Data In: ORACLE - Param = 3, Name = PSTRSQL, Type = fldZSTRING, Precision = 104, Scale = 0, Data =   AND A.JYYWID = B.JYYWID  and b.CBGRQ0 between  '20170214' and '20170214' and b.jgzt00 in ('6','8','9')
5       16:58:50  SQL Execute: ORACLE - BEGIN "SP_JY_ZYZBTJ" (PKSRQ00 => :PKSRQ00,PJSRQ00 => :PJSRQ00,PSTRSQL => :PSTRSQL,PSTRSQL1 => :PSTRSQL1); END;
6       16:58:50  SQL Error: ORACLE - ORA-20910: 执行动态语句:insert into JY_ZYZBTJ_temp(je0000,yqdh00) select sum(zje000) je0000,YQDH00 from (SELECT a.yjksbh, NVL(a.zje000, 0) zje000, c.yqdh00,c.bgr000  FROM  jy_yw0000 c, jy_jyyqzd b WHERE  b.yqdh00=c.yqdh00 and  c.CBGRQ0>='20170214' AND c.CBGRQ0 <= '20170214'  AND a.xmzt00 IN ('2', '3', '4') AND a.yjdjh0 = c.yjdjh0 ) e where e.yjksbh + 0 =  429 GROUP BY YQDH00 时出错。*-904ORA-00904: "A"."YJDJH0": 标识符无效
ORA-06512: 在 "SD_HOSPITAL.SP_EXECUTE_SQL", line 12
ORA-06512: 在 "SD_HOSPITAL.SP_JY
7       16:58:50  SQL Error: ORACLE - Unmapped SQL Error Code: 20910
8       16:59:00  SQL Execute: ORACLE - select count(1) from (select a.MZZYBZ,a.SFTJ00,a.zlxmid,a.jgzt00,a.BBCYRQ,a.BBCYSJ,a.BBSDRQ,a.BBSDSJ,a.PYRQ00,a.PYSJ00,SF_JY_GETTATZZSJ(BBCYRQ,BBCYSJ,BBSDRQ,BBSDSJ,PYRQ00,PYSJ00,MZZYBZ,SFTJ00,JGZT00,zlxmid)SFCTAT from JY_YW0000 a  where a.cbgrq0 is null and a.JGZT00||'A' in ('1A','2A','4A','5A') and a.BBCYRQ between '20170213' and '20170214')t where t.SFCTAT ='Y'