1       10:13:26  Log started for: 易联众医院信息综合管理平台
2       10:13:26  SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

3       10:13:26  SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,BZ0000)  select '192.168.202.164','99',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@' from v$session where  AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 

4       10:13:26  SQL Data In: ORACLE - Rows affected = 1
5       10:13:26  SQL Execute: ORACLE -  Commit 

6       10:13:26  SQL Data In: ORACLE - Rows affected = 0
7       10:13:26  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

8       10:13:26  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='100052' and CZBZ00 in ('0','1') 

9       10:13:26  SQL Execute: ORACLE - select count(*) COUNT0 from XT_XTYCRZ where XKH000 = '100052' and YCLBBZ ='0' and CLBZ00 = '0'

10      10:13:26  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_YHMMZDCSCS'

11      10:13:26  SQL Execute: ORACLE - select distinct XTDM00,XTMC00,XTBMXZ,DLFS00,TPSYH0,BJTP00,XTBB00,BBXH00 from  VW_XT_YHBMQX_EXT where YGBH00=1241 and XTDM00 not in ('OE','MC') order by XTDM00

12      10:13:26  SQL Execute: ORACLE - Select SYSDATE from Dual

13      10:13:26  SQL Execute: ORACLE -  Select SYSDATE from Dual 

14      10:13:26  SQL Execute: ORACLE - select XKH000,ZWXM00,BMBH00,BMMC00,BMYYID,BMYYMC,YBYGDM,YBYGDM_EX from VW_BM_YGBM00_EXT where YGBH00= 1241

15      10:13:26  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where YGBH00 = 1241

16      10:13:26  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where DECODE(SYXT00,NULL,'-1',SYXT00) in ('999','-1')

17      10:13:27  SQL Execute: ORACLE - select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

18      10:13:27  SQL Execute: ORACLE - select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

19      10:13:27  SQL Execute: ORACLE - select SJKYH0,DBBB00 from XT_DBMS00 where upper(SJKYH0) = upper('sd_hospital')

20      10:13:27  SQL Execute: ORACLE - select INSTANCE_NAME,HOST_NAME from V$INSTANCE

21      10:13:27  SQL Execute: ORACLE - select ZBDM00 from XT_YHZB00 where YGBH00 = 1241

22      10:13:27  SQL Execute: ORACLE - select YGBH00,YGXKH0,YGXM00,JSID00,JSMC00,JSDESC,JSLX00 from VW_PT_YGJSB0 where YGBH00 = 1241

23      10:13:27  SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000= '192.168.202.164' 

24      10:13:27  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00='XT_MMQDYZTSDJ'

25      10:13:27  SQL Execute: ORACLE -  select YGBH00,XKH000,ZWXM00,XTDM00,XTMC00,DLKS00,BMMC00,DLRQSJ from VW_XT_XTDLRZ  where YGBH00 = 1241 and RowNum <= 10 order by DLRQSJ DESC 

26      10:13:27  SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1241 and XTDM00='4' order by BMPLXH,BMBH00

27      10:13:28  SQL Execute: ORACLE - select distinct BMBH00,BMMC00,BMXZ00,BMPLXH,YYID00,YYQC00,YYJC00,GJBZBM,GJBZBM_EX from VW_XT_YHBMQX_EXT where YGBH00 = 1241 and XTDM00='5' order by BMPLXH,BMBH00

28      10:13:28  SQL Execute: ORACLE - select MKNBMC from VW_XT_XTKJMK where XTDM00='5' and KJLB00 ='3' 

29      10:13:28  SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKWBJC,KJLB00,KJJ000,XH0000,TBSYH0,KJQDFS from VW_XT_XTKJMK  where XTDM00 = '5' and KJLB00 < '3' order by XH0000

30      10:13:28  SQL Execute: ORACLE - select * from XT_XTCS00 where instr(','||SYXT00||',',','||'5'||',')>0

31      10:13:28  SQL Execute: ORACLE - select XTDM00,MKNBMC,MKWBMC,MKDLL0,TBSYH0 from VW_PT_YHGNMK where YGBH00 = 1241 and XTDM00 = '5' 

32      10:13:28  SQL Execute: ORACLE - select XTDM00,JHGNID,RQLMC0,KJNAME,KJLMC0,KJMS00,MKNBMC,MKDLL0 from VW_XT_XTGNKJ where XTDM00 = '5' 

33      10:13:28  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
494 and FLAG00 like '0'
 order by decode(CKBH00,862,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

34      10:13:28  SQL Execute: ORACLE - select * from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(serial#) from  v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1))

35      10:13:28  SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,SERIAL,BZ0000,JCID00)  select '192.168.202.164','5',nvl(PROGRAM,'未取到'),to_char(SID),to_char(serial#),'scott@',AUDSID from v$session where  AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 

36      10:13:28  SQL Data In: ORACLE - Rows affected = 1
37      10:13:28  SQL Execute: ORACLE - Commit

38      10:13:28  SQL Data In: ORACLE - Rows affected = 0
39      10:13:28  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 

40      10:13:28  SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000  from XT_XTLJ00 where (SID000,SERIAL) in (select to_char(SID),to_char(SERIAL#) from V$session where  AUDSID= userenv('SESSIONID'))

41      10:13:28  SQL Execute: ORACLE - insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00,IP0000)  values(4118763,1241,'YR200619-WRBZ','5',nvl('22024783',' '),'192.168.202.164#714:15737@appYLZHis.exe',494,'192.168.202.164')

42      10:13:28  SQL Data In: ORACLE - Rows affected = 1
43      10:13:28  SQL Execute: ORACLE - Commit

44      10:13:28  SQL Data In: ORACLE - Rows affected = 0
45      10:13:28  SQL Execute: ORACLE - select count(*) from VW_XT_YHKJMK  where YGBH00=1241 and XTDM00='5' 

46      10:13:28  SQL Execute: ORACLE - select * from XT_BJCS00 where IP0000 = '192.168.202.164' and NAME00 = 'QDXTJZ' 

47      10:13:28  SQL Execute: ORACLE -  select JGID00,MKNBMC,MKWBMC,XTDM00,MKDLL0,JGLB00,FJGID0,XH0000,MKFGF0,XSLB00,TBSYH0  from (  select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00, -1 as TBSYH0  from XT_MKJG00 a where a.JGLB00+0 =0 and a.XTDM00 = '5' union all select a.JGID00,a.MKNBMC,a.MKWBMC,a.XTDM00,a.MKDLL0,a.JGLB00,a.FJGID0,a.XH0000,a.MKFGF0,a.XSLB00,a.TBSYH0  from VW_PT_YHCDMK_JG a where YGBH00 = 1241 and XTDM00 = '5') c  order by c.XH0000,c.JGLB00,c.FJGID0,c.JGID00

48      10:13:28  SQL Execute: ORACLE - select MKNBMC,MKWBMC,XTDM00,MKDLL0,TBSYH0 from VW_PT_YHCDMK where YGBH00 = 1241 and XTDM00= '+' and MKDLL0 in ('DLL_GGMK_ZHYW.dll','DLL_GGMK_CXTJ.dll')

49      10:13:28  SQL Execute: ORACLE - select KJID00,YGBH00,XTDM00,MKNBMC,MKWBMC,MKDLL0,XH0000,TBSYH0 from VW_XT_YHKJMK  where YGBH00=1241 and XTDM00='5' order by XH0000

50      10:13:29  SQL Misc: ORACLE - Set stored procedure on or off
51      10:13:29  SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
52      10:13:29  SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
53      10:13:29  SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
54      10:13:29  SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END;
55      10:13:29  SQL Misc: ORACLE - Set stored procedure on or off
56      10:13:29  SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
57      10:13:29  SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
58      10:13:29  SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21977640.000000
59      10:13:29  SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END;
60      10:13:29  SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1241 and CZXH00 = 21977640.00)

61      10:13:29  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL'

62      10:13:29  SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='5'

63      10:13:29  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00

64      10:13:29  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
and KLDH00 = ''

65      10:13:29  SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=494 

66      10:13:29  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=494 

67      10:13:29  SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220035'

68      10:13:29  SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL

69      10:13:29  SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual

70      10:13:29  SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(494) as SFBZDJ from dual

71      10:13:29  SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_ZYSF_CXTJ.dll' and YGBH00 = 1241 

72      10:13:29  SQL Execute: ORACLE -  select name00,value0 from XT_XTCS00 where NAME00 in ('YF_AutoMatch','XT_JEQZ00','ZY_RQDGSCS','ZY_FPTHBJXX') 

73      10:13:29  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '福建预交金统一平台' and BH0000 = 'Open_ZY'

74      10:13:29  SQL Execute: ORACLE -  select  *  from  IC_YBBRLB WHERE YBLB00='Z'

75      10:13:29  SQL Execute: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_LXBRSFKYYF'

76      10:13:29  SQL Execute: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_YJJDTOPLEFT'

77      10:13:29  SQL Execute: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_YJJTKDTOPLEFT'

78      10:13:29  SQL Execute: ORACLE -  select * from BM_YBBCLX where substr(YBYLZD,1,4)='YBYL' and YBYLZD>='YBYL01' order by YBYLZD

79      10:13:29  SQL Execute: ORACLE -  select * from BM_YBBCLX where substr(YBYLZD,1,4)='YBSM' and YBYLZD>='YBSM01' order by YBYLZD

80      10:13:29  SQL Execute: ORACLE - select SF_ZY_GETZYXHLYBYBMBH(494) as ZYXHLY from dual

81      10:13:29  SQL Execute: ORACLE - select SF_ZY_GETZYXHQZBYBMBH(494) as ZYXHQZ from dual

82      10:13:29  SQL Execute: ORACLE - select SF_XT_GETZYSQValidDays as ZYSQTS from dual

83      10:13:29  SQL Execute: ORACLE - select JKLXBM,JKLXMC from VW_ZY_KSJSJKLX order by JKLXBM

84      10:13:29  SQL Execute: ORACLE - select nvl(SF_SF_TYZD00('电子虚拟健康卡', 'Open_MZ'), 'N') VALUE0 from dual

85      10:13:29  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'

86      10:13:29  SQL Execute: ORACLE - select * from VW_ZY_YJJPJ0_JZY where CZY000= -1 and JKDID0 = 0 and JFRQ00 <= ''   and JFRQ00||JFSJ00 <= ''  order by PXH000,PJXH00

87      10:13:29  SQL Execute: ORACLE - select * from VW_ZY_PJSYQK_NEW where PLBH00 in (3,6,4,8,10,20) and CZY000 = 1241   and DYRQ00>= '00000000' and DYRQ00<= '00000000' and DYRQ00||DYSJ00>='0000000000:00:00' and DYRQ00||DYSJ00<='0000000023:59:59' order by PLBH00,PJXH00

88      10:13:29  SQL Execute: ORACLE - select * from VW_ZY_PJSYQK_NEW where PLBH00 in (3,6,4,8,10,20) and CZY000 = 1241   and DYRQ00>= '20220408' and DYRQ00<= '00000000' and DYRQ00||DYSJ00>='2022040800:00:00' and DYRQ00||DYSJ00<='0000000023:59:59' order by PLBH00,PJXH00

89      10:13:29  SQL Execute: ORACLE - select * from VW_ZY_PJSYQK_NEW where PLBH00 in (3,6,4,8,10,20) and CZY000 = 1241   and DYRQ00>= '20220408' and DYRQ00<= '20220408' and DYRQ00||DYSJ00>='2022040800:00:00' and DYRQ00||DYSJ00<='2022040823:59:59' order by PLBH00,PJXH00

90      10:13:29  SQL Execute: ORACLE - select * from VW_ZY_JKB000 where CZY000 = 1241 and JKRQ00>= '20220408' and JKRQ00<= '20220408' and JKRQ00||JKSJ00>='2022040800:00:00' and JKRQ00||JKSJ00<='2022040823:59:59' order by JKDH00

91      10:13:29  SQL Execute: ORACLE - select * from VW_ZY_YJJDL0 where DLR000 = 1241 and JFRQ00>= '20220408' and JFRQ00<= '20220408' and JFRQ00||JFSJ00>='2022040800:00:00' and JFRQ00||JFSJ00<='2022040823:59:59' order by DJH000 

92      10:13:30  SQL Execute: ORACLE - select * from VW_ZY_YJJDL0 where JFCZY0 = 1241 and JFRQ00>= '20220408' and JFRQ00<= '20220408' and JFRQ00||JFSJ00>='2022040800:00:00' and JFRQ00||JFSJ00<='2022040823:59:59' order by DJH000 

93      10:13:30  SQL Execute: ORACLE - select * from VW_ZY_FBXGRZ where CZY000 = 1241 and CZRQ00>= '20220408' and CZRQ00<= '20220408' and CZRQ00||CZSJ00>='2022040800:00:00' and CZRQ00||CZSJ00<='2022040823:59:59' order by CZRQ00,CZSJ00 

94      10:13:30  SQL Execute: ORACLE - select * from VW_BM_BRXXB3 where CZY000 = 1241 and CZRQ00>= '20220408' and CZRQ00<= '20220408' and CZRQ00||CZSJ00>='2022040800:00:00' and CZRQ00||CZSJ00<='2022040823:59:59' order by ICKH00

95      10:13:31  SQL Execute: ORACLE - select YGBH00,ZWXM00||'\'||XKH000 MC0000 from VW_ZY_SFY000

96      10:13:31  SQL Execute: ORACLE - select * from  VW_BM_PJLYQK  where  PJLXBM  in (3,6,4,8,10,20) and PJZT00 in ('未用','在用' ) and PJSYR0 = 1241  order by PJZT00 desc,PJLXBM,PJFFRQ

97      10:13:31  SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00)  values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1241,'刘和琴','192.168.202.164','00-23-24-AD-2D-4B','5','ACT_ZYSF_SFZHCX','22024783')

98      10:13:31  SQL Data In: ORACLE - Rows affected = 1
99      10:13:31  SQL Execute: ORACLE - Commit

100     10:13:31  SQL Data In: ORACLE - Rows affected = 0
101     10:13:32  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL'

102     10:13:32  SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='5'

103     10:13:32  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
Order by SYBZ00

104     10:13:32  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK')
and KLDH00 = ''

105     10:13:32  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL'

106     10:13:32  SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='5'

107     10:13:32  SQL Execute: ORACLE - select BMXZ00 from BM_BMBM00 where BMBH00=494 

108     10:13:32  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00=494 

109     10:13:32  SQL Execute: ORACLE - select max(YYJC00) as YYJC00 from XT_YYXX00 where YYID00='220035'

110     10:13:32  SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from DUAL

111     10:13:32  SQL Execute: ORACLE - select SF_XT_GETDJSFEXIST as SFBZDJ from dual

112     10:13:32  SQL Execute: ORACLE - select SF_XT_GETSFDJBYBMBH(494) as SFBZDJ from dual

113     10:13:32  SQL Execute: ORACLE - select * from VW_XT_BGSZJY where MKDLL0 = 'DLL_ZYSF_ZHYW.dll' and YGBH00 = 1241 

114     10:13:32  SQL Execute: ORACLE -  select name00,value0 from XT_XTCS00 where NAME00 in ('YF_AutoMatch','XT_JEQZ00','ZY_RQDGSCS','ZY_FPTHBJXX') 

115     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '福建预交金统一平台' and BH0000 = 'Open_ZY'

116     10:13:32  SQL Execute: ORACLE -  select  *  from  IC_YBBRLB WHERE YBLB00='Z'

117     10:13:32  SQL Execute: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_LXBRSFKYYF'

118     10:13:32  SQL Execute: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_YJJDTOPLEFT'

119     10:13:32  SQL Execute: ORACLE - select  VALUE0 from  xt_xtcs00  where  name00 = 'ZY_YJJTKDTOPLEFT'

120     10:13:32  SQL Execute: ORACLE -  select * from BM_YBBCLX where substr(YBYLZD,1,4)='YBYL' and YBYLZD>='YBYL01' order by YBYLZD

121     10:13:32  SQL Execute: ORACLE -  select * from BM_YBBCLX where substr(YBYLZD,1,4)='YBSM' and YBYLZD>='YBSM01' order by YBYLZD

122     10:13:32  SQL Execute: ORACLE - select SF_ZY_GETZYXHLYBYBMBH(494) as ZYXHLY from dual

123     10:13:32  SQL Execute: ORACLE - select SF_ZY_GETZYXHQZBYBMBH(494) as ZYXHQZ from dual

124     10:13:32  SQL Execute: ORACLE - select SF_XT_GETZYSQValidDays as ZYSQTS from dual

125     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'Open_ZY'

126     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'YBJYDZ_ZY'

127     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'Start_ZY'

128     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'Open_MZ'

129     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'YBJYDZ_MZ'

130     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'Start_MZ'

131     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'YBJK_Type'

132     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'JSSFFSYBXXZGCX'

133     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'Default_YBJK_Type_MZ'

134     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'Default_YBJK_Type_ZY'

135     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'YBJK_Type_Select'

136     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'YBXJKSQM'

137     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'Update_MZ'

138     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'YBOneLogin'

139     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'DJCXTBMXZF'

140     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'NoCardSettlement'

141     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'ZGCXSFXYZDK'

142     10:13:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'BSYYBJKXT'

143     10:13:32  SQL Execute: ORACLE - select SF_XT_XYBJKSFXYDL('ACT_ZYSF_YW_CYJS') SFXYDL from dual

144     10:13:32  SQL Execute: ORACLE - select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='Nation_AuthorizationCode' 

145     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

146     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

147     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

148     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

149     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

150     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

151     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

152     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

153     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

154     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

155     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

156     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

157     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

158     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

159     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

160     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

161     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

162     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

163     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

164     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

165     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

166     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

167     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

168     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

169     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

170     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

171     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

172     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

173     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

174     10:13:32  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

175     10:13:32  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置
176     10:13:32  SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 

177     10:13:32  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
178     10:13:32  SQL Execute: ORACLE - select B.GJBZBM as usr ,nvl(B.GJYBMM,b.YBYHMM) as pwd  from  BM_BMBM00 A,XT_YYXX00 B 
 where  A.YYID00=B.YYID00 and  A.BMBH00=?

179     10:13:32  SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from dual

180     10:13:32  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YHDL_0000
181     10:13:32  SQL Execute: ORACLE - Select *  from  BM_TYCJBM where CJBM00=?

182     10:13:32  SQL Execute: ORACLE - select SQ_ZY_YBJKRZ_YBJKID.Nextval from  dual

183     10:13:32  SQL Execute: ORACLE - insert into ZY_YBJKRZ(YBJKID,serip0,sermac,ECINFO,HISCS0)values ('169316','192.168.202.164','00_23_24_AD_2D_4B','','')

184     10:13:32  SQL Data In: ORACLE - Rows affected = 1
185     10:13:32  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YHDL_0000
186     10:13:32  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
187     10:13:32  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
188     10:13:32  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
189     10:13:32  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
190     10:13:32  SQL Execute: ORACLE - Select SF_XT_GETCJBM_YBNODE(?,?,?,?,?) as FHXX00 from dual 

191     10:13:32  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169316
192     10:13:32  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = AllIn
193     10:13:32  SQL Execute: ORACLE - Select a.JKSXBM,a.JKSXMC,a.JKFSZ0,a.JKFHZ0
from ZY_YBJKMX a 
where a.YBJKID=? and a.CJBM00=? and a.FSLXBZ in ('1','3') 
order by a.JKMXID

194     10:13:32  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169316
195     10:13:32  SQL Execute: ORACLE - select * from ZY_YBJKRZ  where YBJKID=?

196     10:13:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
197     10:13:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
198     10:13:42  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
199     10:13:42  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
200     10:13:42  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
201     10:13:42  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169316
202     10:13:42  SQL Execute: ORACLE - update zy_YBJKRZ set DLLZT0=?,FLAG=?,CAUSE=?,infcode=?,err_msg=? where YBJKID=?

203     10:13:42  SQL Data In: ORACLE - Rows affected = 1
204     10:13:42  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

205     10:13:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169316
206     10:13:42  SQL Execute: ORACLE -  select *  from ZY_YBJKRZ  where YBJKID=?

207     10:13:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169316
208     10:13:42  SQL Execute: ORACLE -  select *  from ZY_YBJKRZ  where YBJKID=?

209     10:13:42  SQL Execute: ORACLE - select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='Nation_AuthorizationCode' 

210     10:13:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置
211     10:13:42  SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 

212     10:13:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
213     10:13:42  SQL Execute: ORACLE - select B.GJBZBM as usr ,nvl(B.GJYBMM,b.YBYHMM) as pwd  from  BM_BMBM00 A,XT_YYXX00 B 
 where  A.YYID00=B.YYID00 and  A.BMBH00=?

214     10:13:42  SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from dual

215     10:13:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBQD_0001
216     10:13:42  SQL Execute: ORACLE - Select *  from  BM_TYCJBM where CJBM00=?

217     10:13:42  SQL Execute: ORACLE - select SQ_ZY_YBJKRZ_YBJKID.Nextval from  dual

218     10:13:42  SQL Execute: ORACLE - insert into ZY_YBJKRZ(YBJKID,serip0,sermac,ECINFO,HISCS0)values ('169318','192.168.202.164','00-23-24-AD-2D-4B','','<MAC>00-23-24-AD-2D-4B</MAC><IP>192.168.202.164</IP><COMMIT>Y</COMMIT>')

219     10:13:42  SQL Data In: ORACLE - Rows affected = 1
220     10:13:42  SQL Misc: ORACLE - Set stored procedure on or off
221     10:13:42  SQL Data In: ORACLE - Param = 1, Name = IN_YBJKID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
222     10:13:42  SQL Data In: ORACLE - Param = 2, Name = IN_JKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBQD_0001
223     10:13:42  SQL Data In: ORACLE - Param = 3, Name = IN_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
224     10:13:42  SQL Data In: ORACLE - Param = 4, Name = IN_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
225     10:13:42  SQL Data In: ORACLE - Param = 5, Name = IN_ZYH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
226     10:13:42  SQL Data In: ORACLE - Param = 6, Name = IN_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
227     10:13:42  SQL Data In: ORACLE - Param = 7, Name = IN_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 刘和琴
228     10:13:42  SQL Data In: ORACLE - Param = 8, Name = IN_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
229     10:13:42  SQL Data In: ORACLE - Param = 9, Name = IN_QQCSID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
230     10:13:42  SQL Data In: ORACLE - Param = 10, Name = IN_XMLSTR, Type = fldZSTRING, Precision = 70, Scale = 0, Data = <MAC>00-23-24-AD-2D-4B</MAC><IP>192.168.202.164</IP><COMMIT>Y</COMMIT>
231     10:13:42  SQL Data In: ORACLE - Param = 11, Name = IN_OTHER0, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 医保用户签到
232     10:13:42  SQL Data In: ORACLE - Param = 12, Name = IN_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
233     10:13:42  SQL Data In: ORACLE - Param = 13, Name = OUT_ZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
234     10:13:42  SQL Data In: ORACLE - Param = 14, Name = OUT_YBJKID, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
235     10:13:42  SQL Data In: ORACLE - Param = 15, Name = OUT_XMLSTR, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
236     10:13:42  SQL Data In: ORACLE - Param = 16, Name = OUT_ERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
237     10:13:42  SQL Execute: ORACLE - BEGIN "SP_ZY_GJYBJK_YBJKRZ" (IN_YBJKID => :IN_YBJKID,IN_JKCJBM => :IN_JKCJBM,IN_BRID00 => :IN_BRID00,IN_ZYID00 => :IN_ZYID00,IN_ZYH000 => :IN_ZYH000,IN_CZY000 => :IN_CZY000,IN_CZYXM0 => :IN_CZYXM0,IN_CZYKS0 => :IN_CZYKS0,IN_QQCSID => :IN_QQCSID,IN_XMLSTR => :IN_XMLSTR,IN_OTHER0 => :IN_OTHER0,IN_COMMIT => :IN_COMMIT,OUT_ZXZT00 => :OUT_ZXZT00,OUT_YBJKID => :OUT_YBJKID,OUT_XMLSTR => :OUT_XMLSTR,OUT_ERRMSG => :OUT_ERRMSG); END;
238     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBQD_0001
239     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
240     10:13:43  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = signIn
241     10:13:43  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
242     10:13:43  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
243     10:13:43  SQL Execute: ORACLE - Select SF_XT_GETCJBM_YBNODE(?,?,?,?,?) as FHXX00 from dual 

244     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
245     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = AllIn
246     10:13:43  SQL Execute: ORACLE - Select a.JKSXBM,a.JKSXMC,a.JKFSZ0,a.JKFHZ0
from ZY_YBJKMX a 
where a.YBJKID=? and a.CJBM00=? and a.FSLXBZ in ('1','3') 
order by a.JKMXID

247     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
248     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBQD_0001
249     10:13:43  SQL Execute: ORACLE - Select a.JKSXBM,a.JKSXMC,a.JKFSZ0,a.JKFHZ0
from ZY_YBJKMX a 
where a.YBJKID=? and a.CJBM00=? and a.FSLXBZ in ('1','3') 
order by a.JKMXID

250     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
251     10:13:43  SQL Execute: ORACLE - select a.serurl,a.infno,a.msgid,a.mdtrtarea_admvs,a.insuplc_admdvs,
a.recer_sys_code,a.dev_no,a.cainfo,a.signtype,a.infver,
a.opter_type,a.opter,a.opter_name,a.inf_time,a.fixmedins_code,a.fixmedins_name,a.sign_no
from ZY_YBJKRZ a where a.YBJKID=?

252     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
253     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
254     10:13:43  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = success
255     10:13:43  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
256     10:13:43  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = success
257     10:13:43  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
258     10:13:43  SQL Execute: ORACLE - update zy_YBJKRZ set DLLZT0=?,FLAG=?,CAUSE=?,infcode=?,err_msg=? where YBJKID=?

259     10:13:43  SQL Data In: ORACLE - Rows affected = 1
260     10:13:43  SQL Execute: ORACLE - COMMIT

261     10:13:43  SQL Data In: ORACLE - Rows affected = 0
262     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
263     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = body
264     10:13:43  SQL Execute: ORACLE - Select  a.JKMXID,a.JKSXBM,a.JKSXMC,a.FSLXBZ,a.ZDLX00,a.JKFSZ0,a.JKFHZ0   from zy_YBJKMX  a where YBJKID=?
 and JDBM00=?
and FSLXBZ  in ('2','3')
 order by  JKMXID

265     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
266     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main
267     10:13:43  SQL Execute: ORACLE - Select  a.JKMXID,a.JKSXBM,a.JKSXMC,a.FSLXBZ,a.ZDLX00,a.JKFSZ0,a.JKFHZ0   from zy_YBJKMX  a where YBJKID=?
 and JDBM00=?
and FSLXBZ  in ('2','3')
 order by  JKMXID

268     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
269     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
270     10:13:43  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = infcode
271     10:13:43  SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=?  and JKSXBM=? 

272     10:13:43  SQL Data In: ORACLE - Rows affected = 1
273     10:13:43  SQL Execute: ORACLE - COMMIT

274     10:13:43  SQL Data In: ORACLE - Rows affected = 0
275     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 30, Scale = 0, Data = 350000202204081013420728101804
276     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
277     10:13:43  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = inf_refmsgid
278     10:13:43  SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=?  and JKSXBM=? 

279     10:13:43  SQL Data In: ORACLE - Rows affected = 1
280     10:13:43  SQL Execute: ORACLE - COMMIT

281     10:13:43  SQL Data In: ORACLE - Rows affected = 0
282     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = 20220408101342675
283     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
284     10:13:43  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = refmsg_time
285     10:13:43  SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=?  and JKSXBM=? 

286     10:13:43  SQL Data In: ORACLE - Rows affected = 1
287     10:13:43  SQL Execute: ORACLE - COMMIT

288     10:13:43  SQL Data In: ORACLE - Rows affected = 0
289     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = 20220408101342695
290     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
291     10:13:43  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = respond_time
292     10:13:43  SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=?  and JKSXBM=? 

293     10:13:43  SQL Data In: ORACLE - Rows affected = 1
294     10:13:43  SQL Execute: ORACLE - COMMIT

295     10:13:43  SQL Data In: ORACLE - Rows affected = 0
296     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = success
297     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
298     10:13:43  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = err_msg
299     10:13:43  SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=?  and JKSXBM=? 

300     10:13:43  SQL Data In: ORACLE - Rows affected = 1
301     10:13:43  SQL Execute: ORACLE - COMMIT

302     10:13:43  SQL Data In: ORACLE - Rows affected = 0
303     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBQD_0001
304     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
305     10:13:43  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = signinoutb
306     10:13:43  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
307     10:13:43  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
308     10:13:43  SQL Execute: ORACLE - Select SF_XT_GETCJBM_YBNODE(?,?,?,?,?) as FHXX00 from dual 

309     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
310     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = signinoutb
311     10:13:43  SQL Execute: ORACLE - Select a.JKMXID,a.JKSXBM,a.JKSXMC,a.FSLXBZ,a.ZDLX00,a.JKFSZ0,a.JKFHZ0   from zy_YBJKMX a where YBJKID=?
 and JDBM00=?
and FSLXBZ  in ('2','3')
 and CJBM00 not in ('AllIn','AllOut') 
 order by  JKMXID

312     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 19, Scale = 0, Data = 2022-04-08 10:13:42
313     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
314     10:13:43  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = sign_time
315     10:13:43  SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=?  and JKSXBM=? 

316     10:13:43  SQL Data In: ORACLE - Rows affected = 1
317     10:13:43  SQL Execute: ORACLE - COMMIT

318     10:13:43  SQL Data In: ORACLE - Rows affected = 0
319     10:13:43  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 977462
320     10:13:43  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
321     10:13:43  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = sign_no
322     10:13:43  SQL Execute: ORACLE - update ZY_YBJKMX set JKFHZ0=? where YBJKID=?  and JKSXBM=? 

323     10:13:43  SQL Data In: ORACLE - Rows affected = 2
324     10:13:43  SQL Execute: ORACLE - COMMIT

325     10:13:43  SQL Data In: ORACLE - Rows affected = 0
326     10:13:44  SQL Misc: ORACLE - Set stored procedure on or off
327     10:13:44  SQL Data In: ORACLE - Param = 1, Name = IN_YBJKID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
328     10:13:44  SQL Data In: ORACLE - Param = 2, Name = IN_JKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBQD_0001
329     10:13:44  SQL Data In: ORACLE - Param = 3, Name = IN_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
330     10:13:44  SQL Data In: ORACLE - Param = 4, Name = IN_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
331     10:13:44  SQL Data In: ORACLE - Param = 5, Name = IN_ZYH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
332     10:13:44  SQL Data In: ORACLE - Param = 6, Name = IN_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
333     10:13:44  SQL Data In: ORACLE - Param = 7, Name = IN_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 刘和琴
334     10:13:44  SQL Data In: ORACLE - Param = 8, Name = IN_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
335     10:13:44  SQL Data In: ORACLE - Param = 9, Name = IN_QQCSID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
336     10:13:44  SQL Data In: ORACLE - Param = 10, Name = IN_XMLSTR, Type = fldZSTRING, Precision = 70, Scale = 0, Data = <MAC>00-23-24-AD-2D-4B</MAC><IP>192.168.202.164</IP><COMMIT>Y</COMMIT>
337     10:13:44  SQL Data In: ORACLE - Param = 11, Name = IN_OTHER0, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 医保用户签到
338     10:13:44  SQL Data In: ORACLE - Param = 12, Name = IN_COMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
339     10:13:44  SQL Data In: ORACLE - Param = 13, Name = OUT_ZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
340     10:13:44  SQL Data In: ORACLE - Param = 14, Name = OUT_XMLSTR, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
341     10:13:44  SQL Data In: ORACLE - Param = 15, Name = OUT_ERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
342     10:13:44  SQL Execute: ORACLE - BEGIN "SP_ZY_GJYBJK_YBJKQR" (IN_YBJKID => :IN_YBJKID,IN_JKCJBM => :IN_JKCJBM,IN_BRID00 => :IN_BRID00,IN_ZYID00 => :IN_ZYID00,IN_ZYH000 => :IN_ZYH000,IN_CZY000 => :IN_CZY000,IN_CZYXM0 => :IN_CZYXM0,IN_CZYKS0 => :IN_CZYKS0,IN_QQCSID => :IN_QQCSID,IN_XMLSTR => :IN_XMLSTR,IN_OTHER0 => :IN_OTHER0,IN_COMMIT => :IN_COMMIT,OUT_ZXZT00 => :OUT_ZXZT00,OUT_XMLSTR => :OUT_XMLSTR,OUT_ERRMSG => :OUT_ERRMSG); END;
343     10:13:44  SQL Execute: ORACLE - COMMIT

344     10:13:44  SQL Data In: ORACLE - Rows affected = 0
345     10:13:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
346     10:13:44  SQL Execute: ORACLE -  select *  from ZY_YBJKRZ  where YBJKID=?

347     10:13:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
348     10:13:44  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = sign_no
349     10:13:44  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
350     10:13:44  SQL Execute: ORACLE -  select SF_ZY_GETYBJKMX(?,?,?) as FHXX00 from dual 

351     10:13:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
352     10:13:44  SQL Execute: ORACLE -  select *  from ZY_YBJKRZ  where YBJKID=?

353     10:13:44  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 169318
354     10:13:44  SQL Execute: ORACLE -  select *  from ZY_YBJKRZ  where YBJKID=?

355     10:13:44  SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='第三方电子发票平台接口' 

356     10:13:44  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '通用平台病人主索引接口设置' and BH0000 = 'OPEN_ZY'

357     10:13:44  SQL Execute: ORACLE - select JKLXBM,JKLXMC from VW_ZY_KSJSJKLX order by JKLXBM

358     10:13:44  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'Open_ZY'

359     10:13:44  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'Open_MZ'

360     10:13:44  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'JKQYSQM'

361     10:13:44  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'SFJYSZFW'

362     10:13:44  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'CYJSZFYM'

363     10:13:44  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'ZYYJJSTDJDYZFFS'

364     10:13:44  SQL Execute: ORACLE - select sysdate from dual

365     10:13:44  SQL Execute: ORACLE - select BH0000,MC0000 from VW_BM_NEWYBJK_YBJKLX where SFYX00='1' order by XSXH00

366     10:13:44  SQL Execute: ORACLE - select BH0000,MC0000 from VW_BM_SFRZLX where YBJKLX='1' order by XSXH00

367     10:13:44  SQL Execute: ORACLE - select BH0000,MC0000 from VW_BM_SFRZLX where YBJKLX='1' order by XSXH00

368     10:13:44  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'FYMXDCSCBS'

369     10:13:44  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'SFQYZHDKXZ'

370     10:13:44  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'SFQYGJKKXZ'

371     10:13:44  SQL Execute: ORACLE - select sysdate from dual

372     10:13:44  SQL Execute: ORACLE - select 0 as XZ0000,a.* from VW_ZY_FYMX00 a where ZYID00 = -1.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' and nvl(YEXM00,'全部')='' order by MXID00

373     10:13:44  SQL Execute: ORACLE - select * from VW_ZY_BRJFB0 where ZYID00 = -1.00 and JZDH00+0 = 0 and PLBH00 in (4,8) order by DJH000

374     10:13:44  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0_EXT where BRID00 = -1.00 and ZYID00<> -1.00 order by ZYID00 desc 

375     10:13:44  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = -1.00 

376     10:13:44  SQL Execute: ORACLE - select ZYFPID,ZYFPMC,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from VW_ZY_FYMX00  where ZYID00 = -1.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' and nvl(YEXM00,'全部')='' group by ZYFPID,ZYFPMC

377     10:13:44  SQL Execute: ORACLE - select ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH,sum(XMSL00) XMSL00,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from  VW_ZY_FYMX00   where ZYID00 = -1.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' and nvl(YEXM00,'全部')='' group by ZYFPID,ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH

378     10:13:44  SQL Execute: ORACLE - select * from VW_ZY_JZB000 where ZYID00 = -1.00 order by JZDH00

379     10:13:44  SQL Execute: ORACLE - select * from VW_ZY_YZYPSQ_WQY where ZYID00 = -1.00 and SRRQ00 <= '20220408' order by SRRQ00,SRSJ00 

380     10:13:44  SQL Execute: ORACLE - select a.* from VW_ZY_YJTFMX_WZX a where a.ZYID00 = -1.00   and a.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b where b.ZYGHID = a.ZYID00  and b.SFDJH0 in ( select c.DJH000 from ZY_FYMX00 c where c.ZYID00=a.ZYID00 and c.JZDH00+0 = 0 and c.CZRQ00<= '20220408') )  order by a.KDRQ00 desc 

381     10:13:44  SQL Execute: ORACLE - select a.* from VW_ZY_YPTFMX_WZX a where a.ZYID00 = -1.00   and a.CXPCID in (select YPQLPC from  YF_YZYPSQ e,ZY_FYMX00 f where e.DJH000 = f.DJH000 and f.JZDH00+0 = 0     and f.ZYID00=a.ZYID00 and f.CZRQ00 <= '20220408')  order by a.SRRQ00  desc 

382     10:13:44  SQL Execute: ORACLE - select * from VW_BQ_BRZDXX where ZYID00 = -1.00 order by ZDRQ00,ZDSJ00

383     10:13:44  SQL Execute: ORACLE - select nvl(sum(NVL(HJJE00,0)),0) HJJE00, nvl(sum(NVL(ZFJE00,0)),0) ZFJE00, nvl(sum(NVL(JZJE00,0)),0) JZJE00, nvl(sum(NVL(GFJE00,0)),0) GFJE00, nvl(sum(nvl(JMJE00,0)),0) JMJE00, nvl(min(DJH000),0) QSDJH0,nvl(max(DJH000),0) ZZDJH0,   nvl(max(YEXM00),'全部') YEXM00, nvl(min(QDRQ00),'19000101') JSQSRQ, nvl(max(QDRQ00),'20220408') JSJZRQ from VW_ZY_FYMX00 where JZDH00+0 = 0 and JFLBID = 2 and ZYID00 = -1.00 and CZRQ00<= '20220408' and YEXM00 = '' 

384     10:13:44  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = -1.00 

385     10:13:44  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

386     10:13:45  SQL Execute: ORACLE - select sysdate from dual

387     10:13:45  SQL Execute: ORACLE - select nvl(SF_SF_TYZD00('电子虚拟健康卡', 'Open_MZ'), 'N') VALUE0 from dual

388     10:13:45  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'

389     10:13:45  SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00)  values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1241,'刘和琴','192.168.202.164','00-23-24-AD-2D-4B','5','ACT_ZYSF_YW_CYJS','22024783')

390     10:13:45  SQL Data In: ORACLE - Rows affected = 1
391     10:13:45  SQL Execute: ORACLE - Commit

392     10:13:45  SQL Data In: ORACLE - Rows affected = 0
393     10:13:47  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'

394     10:13:47  SQL Execute: ORACLE - Select SYSDATE from Dual

395     10:13:47  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'SLE4442'
and KLDH00 not in ('CK','JMCK')

396     10:13:47  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-FJYB'
and KLDH00 not in ('CK','JMCK')

397     10:13:47  SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00
where SYBZ00 <> '0'
and KLDH00 not in ('ALL','YY-ALL','YB-ALL')
and KLDH00 = 'YB-SBK'
and KLDH00 not in ('CK','JMCK')

398     10:13:48  SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00
where ICKH00 = 'FZYB350200007886'
and ICKNBH = 'FZYB350200007886'

399     10:13:48  SQL Execute: ORACLE - select BRID00  from  IC_YHXX00  where ICKH00 = 'FZYB350200007886' and ZT0000 = '1'

400     10:13:48  SQL Execute: ORACLE - select nvl(max(ZYID00),-1) MAXZYID from ZY_BRXXB0 where BRID00 = 4250243.00 and BRZT00 <> '9' 

401     10:13:48  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00

402     10:13:48  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

403     10:13:48  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保事前控费' and BH0000 = 'SFQYYBSQKF_ZY'

404     10:13:48  SQL Execute: ORACLE - select sysdate from dual

405     10:13:48  SQL Execute: ORACLE - select distinct nvl(YEXM00,'全部') as YEXM00 from VW_ZY_FYMX00 where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00<= '20220408' 

406     10:13:48  SQL Execute: ORACLE - select 0 as XZ0000,a.* from VW_ZY_FYMX00 a where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' order by MXID00

407     10:13:48  SQL Execute: ORACLE - select * from VW_ZY_WSFYMX where ZYID00 = 927436.00 and KDRQ00 <= '20220408' order by SFYP00,ZXKSBH,XMBH00

408     10:13:48  SQL Execute: ORACLE - select * from VW_ZY_BRJFB0 where ZYID00 = 927436.00 and JZDH00+0 = 0 and PLBH00 in (4,8) order by DJH000

409     10:13:48  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0_EXT where BRID00 = 4250243.00 and ZYID00<> 927436.00 order by ZYID00 desc 

410     10:13:49  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00 

411     10:13:49  SQL Execute: ORACLE - select ZYFPID,ZYFPMC,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from VW_ZY_FYMX00  where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' group by ZYFPID,ZYFPMC

412     10:13:49  SQL Execute: ORACLE - select ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH,sum(XMSL00) XMSL00,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from  VW_ZY_FYMX00   where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' group by ZYFPID,ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH

413     10:13:49  SQL Execute: ORACLE - select * from VW_ZY_JZB000 where ZYID00 = 927436.00 order by JZDH00

414     10:13:49  SQL Execute: ORACLE - select * from VW_ZY_YZYPSQ_WQY where ZYID00 = 927436.00 and SRRQ00 <= '20220408' order by SRRQ00,SRSJ00 

415     10:13:49  SQL Execute: ORACLE - select a.* from VW_ZY_YJTFMX_WZX a where a.ZYID00 = 927436.00   and a.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b where b.ZYGHID = a.ZYID00  and b.SFDJH0 in ( select c.DJH000 from ZY_FYMX00 c where c.ZYID00=a.ZYID00 and c.JZDH00+0 = 0 and c.CZRQ00<= '20220408') )  order by a.KDRQ00 desc 

416     10:13:49  SQL Execute: ORACLE - select a.* from VW_ZY_YPTFMX_WZX a where a.ZYID00 = 927436.00   and a.CXPCID in (select YPQLPC from  YF_YZYPSQ e,ZY_FYMX00 f where e.DJH000 = f.DJH000 and f.JZDH00+0 = 0     and f.ZYID00=a.ZYID00 and f.CZRQ00 <= '20220408')  order by a.SRRQ00  desc 

417     10:13:49  SQL Execute: ORACLE - select * from VW_BQ_BRZDXX where ZYID00 = 927436.00 order by ZDRQ00,ZDSJ00

418     10:13:49  SQL Execute: ORACLE - select nvl(sum(NVL(HJJE00,0)),0) HJJE00, nvl(sum(NVL(ZFJE00,0)),0) ZFJE00, nvl(sum(NVL(JZJE00,0)),0) JZJE00, nvl(sum(NVL(GFJE00,0)),0) GFJE00, nvl(sum(nvl(JMJE00,0)),0) JMJE00, nvl(min(DJH000),0) QSDJH0,nvl(max(DJH000),0) ZZDJH0,   nvl(max(YEXM00),'全部') YEXM00, nvl(min(QDRQ00),'19000101') JSQSRQ, nvl(max(QDRQ00),'20220408') JSJZRQ from VW_ZY_FYMX00 where JZDH00+0 = 0 and JFLBID = 2 and ZYID00 = 927436.00 and CZRQ00<= '20220408'

419     10:13:49  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

420     10:13:49  SQL Execute: ORACLE - select max(JSJZRQ) SCJSRQ from ZY_JZB000  where ZYID00=927436.00 and JZZT00='0' and JSLX00='0'  and nvl(CXJZDH,0)=0 and nvl(YEXM00,'全部') in ('全部','婴儿')

421     10:13:50  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

422     10:13:50  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00

423     10:13:50  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

424     10:13:50  SQL Execute: ORACLE - select sysdate from dual

425     10:13:50  SQL Execute: ORACLE - select distinct nvl(YEXM00,'全部') as YEXM00 from VW_ZY_FYMX00 where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00<= '20220408' 

426     10:13:50  SQL Execute: ORACLE - select 0 as XZ0000,a.* from VW_ZY_FYMX00 a where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' order by MXID00

427     10:13:51  SQL Execute: ORACLE - select * from VW_ZY_WSFYMX where ZYID00 = 927436.00 and KDRQ00 <= '20220408' order by SFYP00,ZXKSBH,XMBH00

428     10:13:51  SQL Execute: ORACLE - select * from VW_ZY_BRJFB0 where ZYID00 = 927436.00 and JZDH00+0 = 0 and PLBH00 in (4,8) order by DJH000

429     10:13:51  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0_EXT where BRID00 = 4250243.00 and ZYID00<> 927436.00 order by ZYID00 desc 

430     10:13:51  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00 

431     10:13:51  SQL Execute: ORACLE - select ZYFPID,ZYFPMC,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from VW_ZY_FYMX00  where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' group by ZYFPID,ZYFPMC

432     10:13:51  SQL Execute: ORACLE - select ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH,sum(XMSL00) XMSL00,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from  VW_ZY_FYMX00   where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' group by ZYFPID,ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH

433     10:13:51  SQL Execute: ORACLE - select * from VW_ZY_JZB000 where ZYID00 = 927436.00 order by JZDH00

434     10:13:51  SQL Execute: ORACLE - select * from VW_ZY_YZYPSQ_WQY where ZYID00 = 927436.00 and SRRQ00 <= '20220408' order by SRRQ00,SRSJ00 

435     10:13:51  SQL Execute: ORACLE - select a.* from VW_ZY_YJTFMX_WZX a where a.ZYID00 = 927436.00   and a.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b where b.ZYGHID = a.ZYID00  and b.SFDJH0 in ( select c.DJH000 from ZY_FYMX00 c where c.ZYID00=a.ZYID00 and c.JZDH00+0 = 0 and c.CZRQ00<= '20220408') )  order by a.KDRQ00 desc 

436     10:13:51  SQL Execute: ORACLE - select a.* from VW_ZY_YPTFMX_WZX a where a.ZYID00 = 927436.00   and a.CXPCID in (select YPQLPC from  YF_YZYPSQ e,ZY_FYMX00 f where e.DJH000 = f.DJH000 and f.JZDH00+0 = 0     and f.ZYID00=a.ZYID00 and f.CZRQ00 <= '20220408')  order by a.SRRQ00  desc 

437     10:13:51  SQL Execute: ORACLE - select * from VW_BQ_BRZDXX where ZYID00 = 927436.00 order by ZDRQ00,ZDSJ00

438     10:13:51  SQL Execute: ORACLE - select nvl(sum(NVL(HJJE00,0)),0) HJJE00, nvl(sum(NVL(ZFJE00,0)),0) ZFJE00, nvl(sum(NVL(JZJE00,0)),0) JZJE00, nvl(sum(NVL(GFJE00,0)),0) GFJE00, nvl(sum(nvl(JMJE00,0)),0) JMJE00, nvl(min(DJH000),0) QSDJH0,nvl(max(DJH000),0) ZZDJH0,   nvl(max(YEXM00),'全部') YEXM00, nvl(min(QDRQ00),'19000101') JSQSRQ, nvl(max(QDRQ00),'20220408') JSJZRQ from VW_ZY_FYMX00 where JZDH00+0 = 0 and JFLBID = 2 and ZYID00 = 927436.00 and CZRQ00<= '20220408'

439     10:13:51  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

440     10:13:51  SQL Execute: ORACLE - select max(JSJZRQ) SCJSRQ from ZY_JZB000  where ZYID00=927436.00 and JZZT00='0' and JSLX00='0'  and nvl(CXJZDH,0)=0 and nvl(YEXM00,'全部') in ('全部','婴儿')

441     10:13:51  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '新农合跨省结报参数'

442     10:13:51  SQL Misc: ORACLE - Set stored procedure on or off
443     10:13:51  SQL Data In: ORACLE - Param = 1, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
444     10:13:51  SQL Data In: ORACLE - Param = 2, Name = PJFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
445     10:13:51  SQL Data In: ORACLE - Param = 3, Name = PCZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
446     10:13:51  SQL Data In: ORACLE - Param = 4, Name = PJSZZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220408
447     10:13:51  SQL Data In: ORACLE - Param = 5, Name = PYEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部
448     10:13:51  SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
449     10:13:51  SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
450     10:13:51  SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
451     10:13:51  SQL Data In: ORACLE - Param = 9, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
452     10:13:51  SQL Data In: ORACLE - Param = 10, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
453     10:13:51  SQL Data In: ORACLE - Param = 11, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
454     10:13:51  SQL Execute: ORACLE - BEGIN "SP_ZY_FYJS00_TSXZ00" (PZYID00 => :PZYID00,PJFLBID => :PJFLBID,PCZBZ00 => :PCZBZ00,PJSZZRQ => :PJSZZRQ,PYEXM00 => :PYEXM00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END;
455     10:13:52  SQL Execute: ORACLE - RollBack

456     10:13:52  SQL Data In: ORACLE - Rows affected = 0
457     10:13:52  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

458     10:13:53  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00

459     10:13:53  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

460     10:13:53  SQL Execute: ORACLE - select sysdate from dual

461     10:13:53  SQL Execute: ORACLE - select distinct nvl(YEXM00,'全部') as YEXM00 from VW_ZY_FYMX00 where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00<= '20220408' 

462     10:13:53  SQL Execute: ORACLE - select 0 as XZ0000,a.* from VW_ZY_FYMX00 a where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' order by MXID00

463     10:13:53  SQL Execute: ORACLE - select * from VW_ZY_WSFYMX where ZYID00 = 927436.00 and KDRQ00 <= '20220408' order by SFYP00,ZXKSBH,XMBH00

464     10:13:53  SQL Execute: ORACLE - select * from VW_ZY_BRJFB0 where ZYID00 = 927436.00 and JZDH00+0 = 0 and PLBH00 in (4,8) order by DJH000

465     10:13:53  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0_EXT where BRID00 = 4250243.00 and ZYID00<> 927436.00 order by ZYID00 desc 

466     10:13:54  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00 

467     10:13:54  SQL Execute: ORACLE - select ZYFPID,ZYFPMC,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from VW_ZY_FYMX00  where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' group by ZYFPID,ZYFPMC

468     10:13:54  SQL Execute: ORACLE - select ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH,sum(XMSL00) XMSL00,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from  VW_ZY_FYMX00   where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' group by ZYFPID,ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH

469     10:13:54  SQL Execute: ORACLE - select * from VW_ZY_JZB000 where ZYID00 = 927436.00 order by JZDH00

470     10:13:54  SQL Execute: ORACLE - select * from VW_ZY_YZYPSQ_WQY where ZYID00 = 927436.00 and SRRQ00 <= '20220408' order by SRRQ00,SRSJ00 

471     10:13:54  SQL Execute: ORACLE - select a.* from VW_ZY_YJTFMX_WZX a where a.ZYID00 = 927436.00   and a.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b where b.ZYGHID = a.ZYID00  and b.SFDJH0 in ( select c.DJH000 from ZY_FYMX00 c where c.ZYID00=a.ZYID00 and c.JZDH00+0 = 0 and c.CZRQ00<= '20220408') )  order by a.KDRQ00 desc 

472     10:13:54  SQL Execute: ORACLE - select a.* from VW_ZY_YPTFMX_WZX a where a.ZYID00 = 927436.00   and a.CXPCID in (select YPQLPC from  YF_YZYPSQ e,ZY_FYMX00 f where e.DJH000 = f.DJH000 and f.JZDH00+0 = 0     and f.ZYID00=a.ZYID00 and f.CZRQ00 <= '20220408')  order by a.SRRQ00  desc 

473     10:13:54  SQL Execute: ORACLE - select * from VW_BQ_BRZDXX where ZYID00 = 927436.00 order by ZDRQ00,ZDSJ00

474     10:13:54  SQL Execute: ORACLE - select nvl(sum(NVL(HJJE00,0)),0) HJJE00, nvl(sum(NVL(ZFJE00,0)),0) ZFJE00, nvl(sum(NVL(JZJE00,0)),0) JZJE00, nvl(sum(NVL(GFJE00,0)),0) GFJE00, nvl(sum(nvl(JMJE00,0)),0) JMJE00, nvl(min(DJH000),0) QSDJH0,nvl(max(DJH000),0) ZZDJH0,   nvl(max(YEXM00),'全部') YEXM00, nvl(min(QDRQ00),'19000101') JSQSRQ, nvl(max(QDRQ00),'20220408') JSJZRQ from VW_ZY_FYMX00 where JZDH00+0 = 0 and JFLBID = 2 and ZYID00 = 927436.00 and CZRQ00<= '20220408'

475     10:13:54  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

476     10:13:54  SQL Execute: ORACLE - select max(JSJZRQ) SCJSRQ from ZY_JZB000  where ZYID00=927436.00 and JZZT00='0' and JSLX00='0'  and nvl(CXJZDH,0)=0 and nvl(YEXM00,'全部') in ('全部','婴儿')

477     10:13:56  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

478     10:13:56  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00

479     10:13:56  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

480     10:13:56  SQL Execute: ORACLE - select sysdate from dual

481     10:13:56  SQL Execute: ORACLE - select distinct nvl(YEXM00,'全部') as YEXM00 from VW_ZY_FYMX00 where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00<= '20220408' 

482     10:13:56  SQL Execute: ORACLE - select 0 as XZ0000,a.* from VW_ZY_FYMX00 a where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' order by MXID00

483     10:13:56  SQL Execute: ORACLE - select * from VW_ZY_WSFYMX where ZYID00 = 927436.00 and KDRQ00 <= '20220408' order by SFYP00,ZXKSBH,XMBH00

484     10:13:56  SQL Execute: ORACLE - select * from VW_ZY_BRJFB0 where ZYID00 = 927436.00 and JZDH00+0 = 0 and PLBH00 in (4,8) order by DJH000

485     10:13:57  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0_EXT where BRID00 = 4250243.00 and ZYID00<> 927436.00 order by ZYID00 desc 

486     10:13:57  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00 

487     10:13:57  SQL Execute: ORACLE - select ZYFPID,ZYFPMC,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from VW_ZY_FYMX00  where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' group by ZYFPID,ZYFPMC

488     10:13:57  SQL Execute: ORACLE - select ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH,sum(XMSL00) XMSL00,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from  VW_ZY_FYMX00   where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' group by ZYFPID,ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH

489     10:13:57  SQL Execute: ORACLE - select * from VW_ZY_JZB000 where ZYID00 = 927436.00 order by JZDH00

490     10:13:57  SQL Execute: ORACLE - select * from VW_ZY_YZYPSQ_WQY where ZYID00 = 927436.00 and SRRQ00 <= '20220408' order by SRRQ00,SRSJ00 

491     10:13:57  SQL Execute: ORACLE - select a.* from VW_ZY_YJTFMX_WZX a where a.ZYID00 = 927436.00   and a.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b where b.ZYGHID = a.ZYID00  and b.SFDJH0 in ( select c.DJH000 from ZY_FYMX00 c where c.ZYID00=a.ZYID00 and c.JZDH00+0 = 0 and c.CZRQ00<= '20220408') )  order by a.KDRQ00 desc 

492     10:13:57  SQL Execute: ORACLE - select a.* from VW_ZY_YPTFMX_WZX a where a.ZYID00 = 927436.00   and a.CXPCID in (select YPQLPC from  YF_YZYPSQ e,ZY_FYMX00 f where e.DJH000 = f.DJH000 and f.JZDH00+0 = 0     and f.ZYID00=a.ZYID00 and f.CZRQ00 <= '20220408')  order by a.SRRQ00  desc 

493     10:13:57  SQL Execute: ORACLE - select * from VW_BQ_BRZDXX where ZYID00 = 927436.00 order by ZDRQ00,ZDSJ00

494     10:13:57  SQL Execute: ORACLE - select nvl(sum(NVL(HJJE00,0)),0) HJJE00, nvl(sum(NVL(ZFJE00,0)),0) ZFJE00, nvl(sum(NVL(JZJE00,0)),0) JZJE00, nvl(sum(NVL(GFJE00,0)),0) GFJE00, nvl(sum(nvl(JMJE00,0)),0) JMJE00, nvl(min(DJH000),0) QSDJH0,nvl(max(DJH000),0) ZZDJH0,   nvl(max(YEXM00),'全部') YEXM00, nvl(min(QDRQ00),'19000101') JSQSRQ, nvl(max(QDRQ00),'20220408') JSJZRQ from VW_ZY_FYMX00 where JZDH00+0 = 0 and JFLBID = 2 and ZYID00 = 927436.00 and CZRQ00<= '20220408'

495     10:13:57  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

496     10:13:57  SQL Execute: ORACLE - select max(JSJZRQ) SCJSRQ from ZY_JZB000  where ZYID00=927436.00 and JZZT00='0' and JSLX00='0'  and nvl(CXJZDH,0)=0 and nvl(YEXM00,'全部') in ('全部','婴儿')

497     10:13:57  SQL Misc: ORACLE - Set stored procedure on or off
498     10:13:57  SQL Data In: ORACLE - Param = 1, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
499     10:13:57  SQL Data In: ORACLE - Param = 2, Name = PJFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
500     10:13:57  SQL Data In: ORACLE - Param = 3, Name = PCZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
501     10:13:57  SQL Data In: ORACLE - Param = 4, Name = PJSZZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220408
502     10:13:57  SQL Data In: ORACLE - Param = 5, Name = PYEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部
503     10:13:57  SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
504     10:13:57  SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
505     10:13:57  SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
506     10:13:57  SQL Data In: ORACLE - Param = 9, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
507     10:13:57  SQL Data In: ORACLE - Param = 10, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
508     10:13:57  SQL Data In: ORACLE - Param = 11, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
509     10:13:57  SQL Execute: ORACLE - BEGIN "SP_ZY_FYJS00_TSXZ00" (PZYID00 => :PZYID00,PJFLBID => :PJFLBID,PCZBZ00 => :PCZBZ00,PJSZZRQ => :PJSZZRQ,PYEXM00 => :PYEXM00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END;
510     10:13:58  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'JSSFFSYBXXZGCX'

511     10:13:58  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'JSSFFSYBXXZGCX'

512     10:13:58  SQL Execute: ORACLE - select count(*) from ZY_FYMX00 where ZYID00=927436.00 and YBFSDH='0'

513     10:13:59  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
514     10:13:59  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
515     10:13:59  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
516     10:13:59  SQL Execute: ORACLE - select SF_ZY_GETSFTCSRPTBCTS(?,?,?) SFTCSR from dual

517     10:13:59  SQL Execute: ORACLE - select YBKSBH from VW_BM_BMBM00 where BMBH00 = 491

518     10:13:59  SQL Execute: ORACLE - select count(*) ZJL from ZY_YBFS00 where ZYID00 = 927436.00 and CXBZ00<>'1' 

519     10:13:59  SQL Misc: ORACLE - Set stored procedure on or off
520     10:13:59  SQL Data In: ORACLE - Param = 1, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
521     10:13:59  SQL Data In: ORACLE - Param = 2, Name = AS_QSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
522     10:13:59  SQL Data In: ORACLE - Param = 3, Name = AS_ZZRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
523     10:13:59  SQL Data In: ORACLE - Param = 4, Name = AS_YBMC00, Type = fldZSTRING, Precision = 14, Scale = 0, Data = 福建省两费中心
524     10:13:59  SQL Data In: ORACLE - Param = 5, Name = AS_CLJKGC, Type = fldZSTRING, Precision = 19, Scale = 0, Data = SP_ZY_ZYSF00_YBJK01
525     10:13:59  SQL Data In: ORACLE - Param = 6, Name = AD_YEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部
526     10:13:59  SQL Data In: ORACLE - Param = 7, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
527     10:13:59  SQL Data In: ORACLE - Param = 8, Name = AD_QSDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39559875.000000
528     10:13:59  SQL Data In: ORACLE - Param = 9, Name = AD_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39999323.000000
529     10:13:59  SQL Data In: ORACLE - Param = 10, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
530     10:13:59  SQL Data In: ORACLE - Param = 11, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
531     10:13:59  SQL Execute: ORACLE - BEGIN "SP_ZY_WSPYPTS" (AD_JZDH00 => :AD_JZDH00,AS_QSRQ00 => :AS_QSRQ00,AS_ZZRQ00 => :AS_ZZRQ00,AS_YBMC00 => :AS_YBMC00,AS_CLJKGC => :AS_CLJKGC,AD_YEXM00 => :AD_YEXM00,AD_ZYID00 => :AD_ZYID00,AD_QSDJH0 => :AD_QSDJH0,AD_ZZDJH0 => :AD_ZZDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END;
532     10:13:59  SQL Misc: ORACLE - Set stored procedure on or off
533     10:13:59  SQL Data In: ORACLE - Param = 1, Name = AD_QSDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39559875.000000
534     10:13:59  SQL Data In: ORACLE - Param = 2, Name = AD_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39999323.000000
535     10:13:59  SQL Data In: ORACLE - Param = 3, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
536     10:13:59  SQL Data In: ORACLE - Param = 4, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
537     10:13:59  SQL Data In: ORACLE - Param = 5, Name = AS_QSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220307
538     10:13:59  SQL Data In: ORACLE - Param = 6, Name = AS_ZZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220408
539     10:13:59  SQL Data In: ORACLE - Param = 7, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
540     10:13:59  SQL Data In: ORACLE - Param = 8, Name = AS_FLAG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
541     10:13:59  SQL Data In: ORACLE - Param = 9, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
542     10:13:59  SQL Data In: ORACLE - Param = 10, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
543     10:13:59  SQL Data In: ORACLE - Param = 11, Name = AD_YEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部
544     10:13:59  SQL Data In: ORACLE - Param = 12, Name = AD_SFXYB0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
545     10:13:59  SQL Data In: ORACLE - Param = 13, Name = AD_JSXZID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
546     10:13:59  SQL Data In: ORACLE - Param = 14, Name = AS_INXML0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
547     10:13:59  SQL Execute: ORACLE - BEGIN "SP_ZY_YBJK00_FJ0000" (AD_QSDJH0 => :AD_QSDJH0,AD_ZZDJH0 => :AD_ZZDJH0,AD_JZDH00 => :AD_JZDH00,AD_ZYID00 => :AD_ZYID00,AS_QSRQ00 => :AS_QSRQ00,AS_ZZRQ00 => :AS_ZZRQ00,AD_ID0000 => :AD_ID0000,AS_FLAG00 => :AS_FLAG00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AD_YEXM00 => :AD_YEXM00,AD_SFXYB0 => :AD_SFXYB0,AD_JSXZID => :AD_JSXZID,AS_INXML0 => :AS_INXML0); END;
548     10:14:00  SQL Execute: ORACLE - select SF_ZY_FSDYLX(0,'福建省两费中心') as FSDYLX from dual

549     10:14:00  SQL Execute: ORACLE - select  *  from  VW_ZY_XMFSDY where MRFS00 = '1' order by PXXH00

550     10:14:00  SQL Execute: ORACLE - select  *  from  BM_ZYCF00_TEMP00  where ID0000 = 1721411.00  

551     10:14:00  SQL Execute: ORACLE - select  *  from  BM_ZYCFMX_TEMP00  where ID0000 = 1721411.00  

552     10:14:00  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

553     10:14:00  SQL Execute: ORACLE - update ZY_BRXXB0 set YBJHBZ ='1' where ZYID00 = 927436.00

554     10:14:00  SQL Data In: ORACLE - Rows affected = 1
555     10:14:00  SQL Execute: ORACLE - Commit

556     10:14:00  SQL Data In: ORACLE - Rows affected = 0
557     10:14:30  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'yyyy-MM-dd') OraSysDate FROM DUAL

558     10:14:30  SQL Execute: ORACLE - update ZY_BRXXB0 set YBJHBZ ='2' where ZYID00 = 927436.00

559     10:14:30  SQL Data In: ORACLE - Rows affected = 1
560     10:14:30  SQL Execute: ORACLE - Commit

561     10:14:30  SQL Data In: ORACLE - Rows affected = 0
562     10:14:30  SQL Misc: ORACLE - Set stored procedure on or off
563     10:14:30  SQL Data In: ORACLE - Param = 1, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
564     10:14:30  SQL Data In: ORACLE - Param = 2, Name = AD_QSDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39559875.000000
565     10:14:30  SQL Data In: ORACLE - Param = 3, Name = AD_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39999323.000000
566     10:14:30  SQL Data In: ORACLE - Param = 4, Name = AS_YBFSDH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 245887
567     10:14:30  SQL Data In: ORACLE - Param = 5, Name = AD_GRZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 96.000000
568     10:14:30  SQL Data In: ORACLE - Param = 6, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
569     10:14:30  SQL Data In: ORACLE - Param = 7, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30591.870000
570     10:14:30  SQL Data In: ORACLE - Param = 8, Name = AD_SBGRZH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
571     10:14:30  SQL Data In: ORACLE - Param = 9, Name = AD_SBTCJJ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
572     10:14:30  SQL Data In: ORACLE - Param = 10, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30687.870000
573     10:14:30  SQL Data In: ORACLE - Param = 11, Name = AD_DBGRZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
574     10:14:30  SQL Data In: ORACLE - Param = 12, Name = AD_GSJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
575     10:14:30  SQL Data In: ORACLE - Param = 13, Name = AD_GSZFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
576     10:14:30  SQL Data In: ORACLE - Param = 14, Name = AD_FGSFY0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
577     10:14:30  SQL Data In: ORACLE - Param = 15, Name = AD_BJJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
578     10:14:30  SQL Data In: ORACLE - Param = 16, Name = AD_GWYBZ0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
579     10:14:30  SQL Data In: ORACLE - Param = 17, Name = AD_SYBXZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
580     10:14:30  SQL Data In: ORACLE - Param = 18, Name = AD_FYBFY0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
581     10:14:30  SQL Data In: ORACLE - Param = 19, Name = AD_YLZFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
582     10:14:30  SQL Data In: ORACLE - Param = 20, Name = AD_CFDXJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
583     10:14:30  SQL Data In: ORACLE - Param = 21, Name = AD_SBZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
584     10:14:30  SQL Data In: ORACLE - Param = 22, Name = AD_BJZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
585     10:14:30  SQL Data In: ORACLE - Param = 23, Name = AD_GRZHYE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
586     10:14:30  SQL Data In: ORACLE - Param = 24, Name = AD_YPWQZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
587     10:14:30  SQL Data In: ORACLE - Param = 25, Name = AD_YPBFZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
588     10:14:30  SQL Data In: ORACLE - Param = 26, Name = AD_XMWQZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
589     10:14:30  SQL Data In: ORACLE - Param = 27, Name = AD_XMBFZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
590     10:14:30  SQL Data In: ORACLE - Param = 28, Name = AS_BJJBIE, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 04
591     10:14:30  SQL Data In: ORACLE - Param = 29, Name = AS_YBJZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220408
592     10:14:30  SQL Data In: ORACLE - Param = 30, Name = AS_YBJZSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:01:00
593     10:14:30  SQL Data In: ORACLE - Param = 31, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
594     10:14:30  SQL Data In: ORACLE - Param = 32, Name = AD_CFXMS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
595     10:14:30  SQL Data In: ORACLE - Param = 33, Name = AD_YEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部
596     10:14:30  SQL Data In: ORACLE - Param = 34, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
597     10:14:30  SQL Data In: ORACLE - Param = 35, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
598     10:14:30  SQL Data In: ORACLE - Param = 36, Name = OD_YBZFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
599     10:14:30  SQL Data In: ORACLE - Param = 37, Name = OD_YBZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
600     10:14:30  SQL Data In: ORACLE - Param = 38, Name = OD_YBJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
601     10:14:30  SQL Data In: ORACLE - Param = 39, Name = OD_YBQTZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
602     10:14:30  SQL Data In: ORACLE - Param = 40, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
603     10:14:30  SQL Data In: ORACLE - Param = 41, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
604     10:14:30  SQL Data In: ORACLE - Param = 42, Name = AD_YBYL01, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
605     10:14:30  SQL Data In: ORACLE - Param = 43, Name = AD_YBYL02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
606     10:14:30  SQL Data In: ORACLE - Param = 44, Name = AD_YBYL03, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
607     10:14:30  SQL Data In: ORACLE - Param = 45, Name = AD_YBYL04, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
608     10:14:30  SQL Data In: ORACLE - Param = 46, Name = AD_YBYL05, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
609     10:14:30  SQL Data In: ORACLE - Param = 47, Name = AD_YBYL06, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
610     10:14:30  SQL Data In: ORACLE - Param = 48, Name = AD_YBYL07, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
611     10:14:30  SQL Data In: ORACLE - Param = 49, Name = AD_YBYL08, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
612     10:14:30  SQL Data In: ORACLE - Param = 50, Name = AD_YBYL09, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
613     10:14:30  SQL Data In: ORACLE - Param = 51, Name = AD_YBYL10, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
614     10:14:30  SQL Data In: ORACLE - Param = 52, Name = AD_YBYL11, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
615     10:14:30  SQL Data In: ORACLE - Param = 53, Name = AD_YBYL12, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
616     10:14:30  SQL Data In: ORACLE - Param = 54, Name = AD_YBYL13, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
617     10:14:30  SQL Data In: ORACLE - Param = 55, Name = AD_YBYL14, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
618     10:14:30  SQL Data In: ORACLE - Param = 56, Name = AD_YBYL15, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
619     10:14:30  SQL Data In: ORACLE - Param = 57, Name = AD_YBYL16, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
620     10:14:30  SQL Data In: ORACLE - Param = 58, Name = AD_YBYL17, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
621     10:14:30  SQL Data In: ORACLE - Param = 59, Name = AD_YBYL18, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
622     10:14:30  SQL Data In: ORACLE - Param = 60, Name = AD_YBYL19, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
623     10:14:30  SQL Data In: ORACLE - Param = 61, Name = AD_YBYL20, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
624     10:14:30  SQL Data In: ORACLE - Param = 62, Name = AD_YBYL21, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
625     10:14:30  SQL Data In: ORACLE - Param = 63, Name = AD_YBYL22, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
626     10:14:30  SQL Data In: ORACLE - Param = 64, Name = AD_YBYL23, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
627     10:14:30  SQL Data In: ORACLE - Param = 65, Name = AD_YBYL24, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
628     10:14:30  SQL Data In: ORACLE - Param = 66, Name = AD_YBYL25, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
629     10:14:30  SQL Data In: ORACLE - Param = 67, Name = AD_YBYL26, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
630     10:14:30  SQL Data In: ORACLE - Param = 68, Name = AD_YBYL27, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
631     10:14:30  SQL Data In: ORACLE - Param = 69, Name = AD_YBYL28, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
632     10:14:30  SQL Data In: ORACLE - Param = 70, Name = AD_YBYL29, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
633     10:14:30  SQL Data In: ORACLE - Param = 71, Name = AD_YBYL30, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
634     10:14:30  SQL Data In: ORACLE - Param = 72, Name = AD_YBYL31, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 96.000000
635     10:14:30  SQL Data In: ORACLE - Param = 73, Name = AD_YBYL32, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
636     10:14:30  SQL Data In: ORACLE - Param = 74, Name = AD_YBYL33, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
637     10:14:30  SQL Data In: ORACLE - Param = 75, Name = AD_YBYL34, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
638     10:14:30  SQL Data In: ORACLE - Param = 76, Name = AD_YBYL35, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30687.870000
639     10:14:30  SQL Data In: ORACLE - Param = 77, Name = AD_YBYL36, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
640     10:14:30  SQL Data In: ORACLE - Param = 78, Name = AD_YBYL37, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
641     10:14:30  SQL Data In: ORACLE - Param = 79, Name = AD_YBYL38, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
642     10:14:30  SQL Data In: ORACLE - Param = 80, Name = AD_YBYL39, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
643     10:14:30  SQL Data In: ORACLE - Param = 81, Name = AD_YBYL40, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
644     10:14:30  SQL Data In: ORACLE - Param = 82, Name = AD_YBYL41, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
645     10:14:30  SQL Data In: ORACLE - Param = 83, Name = AD_YBYL42, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
646     10:14:30  SQL Data In: ORACLE - Param = 84, Name = AD_YBYL43, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
647     10:14:30  SQL Data In: ORACLE - Param = 85, Name = AD_YBYL44, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
648     10:14:30  SQL Data In: ORACLE - Param = 86, Name = AD_YBYL45, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
649     10:14:30  SQL Data In: ORACLE - Param = 87, Name = AD_YBYL46, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
650     10:14:30  SQL Data In: ORACLE - Param = 88, Name = AD_YBYL47, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
651     10:14:30  SQL Data In: ORACLE - Param = 89, Name = AD_YBYL48, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
652     10:14:30  SQL Data In: ORACLE - Param = 90, Name = AD_YBYL49, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
653     10:14:30  SQL Data In: ORACLE - Param = 91, Name = AD_YBYL50, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
654     10:14:30  SQL Data In: ORACLE - Param = 92, Name = AD_YBYL51, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
655     10:14:30  SQL Data In: ORACLE - Param = 93, Name = AD_YBYL52, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
656     10:14:30  SQL Data In: ORACLE - Param = 94, Name = AD_YBYL53, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
657     10:14:30  SQL Data In: ORACLE - Param = 95, Name = AD_YBYL54, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
658     10:14:30  SQL Data In: ORACLE - Param = 96, Name = AD_YBYL55, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
659     10:14:30  SQL Data In: ORACLE - Param = 97, Name = AD_YBYL56, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
660     10:14:30  SQL Data In: ORACLE - Param = 98, Name = AD_YBYL57, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
661     10:14:30  SQL Data In: ORACLE - Param = 99, Name = AD_YBYL58, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
662     10:14:30  SQL Data In: ORACLE - Param = 100, Name = AD_YBYL59, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
663     10:14:30  SQL Data In: ORACLE - Param = 101, Name = AD_YBYL60, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
664     10:14:30  SQL Data In: ORACLE - Param = 102, Name = AD_YBYL61, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
665     10:14:30  SQL Data In: ORACLE - Param = 103, Name = AD_YBYL62, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
666     10:14:30  SQL Data In: ORACLE - Param = 104, Name = AD_YBYL63, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
667     10:14:30  SQL Data In: ORACLE - Param = 105, Name = AD_YBYL64, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
668     10:14:30  SQL Data In: ORACLE - Param = 106, Name = AD_YBYL65, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
669     10:14:30  SQL Data In: ORACLE - Param = 107, Name = AD_YBYL66, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
670     10:14:30  SQL Data In: ORACLE - Param = 108, Name = AD_YBYL67, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
671     10:14:30  SQL Data In: ORACLE - Param = 109, Name = AD_YBYL68, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
672     10:14:30  SQL Data In: ORACLE - Param = 110, Name = AD_YBYL69, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
673     10:14:30  SQL Data In: ORACLE - Param = 111, Name = AS_YBSM01, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 本地
674     10:14:30  SQL Data In: ORACLE - Param = 112, Name = AS_YBSM02, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
675     10:14:30  SQL Data In: ORACLE - Param = 113, Name = AS_YBSM03, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
676     10:14:30  SQL Data In: ORACLE - Param = 114, Name = AS_YBSM04, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
677     10:14:30  SQL Data In: ORACLE - Param = 115, Name = AS_YBSM05, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 245887
678     10:14:30  SQL Data In: ORACLE - Param = 116, Name = AS_YBSM06, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
679     10:14:30  SQL Data In: ORACLE - Param = 117, Name = AS_YBSM07, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
680     10:14:30  SQL Data In: ORACLE - Param = 118, Name = AS_YBSM08, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
681     10:14:30  SQL Data In: ORACLE - Param = 119, Name = AS_YBSM09, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
682     10:14:30  SQL Data In: ORACLE - Param = 120, Name = AS_YBSM10, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
683     10:14:30  SQL Data In: ORACLE - Param = 121, Name = AS_YBSM11, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
684     10:14:30  SQL Data In: ORACLE - Param = 122, Name = AS_YBSM12, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
685     10:14:30  SQL Data In: ORACLE - Param = 123, Name = AS_YBSM13, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
686     10:14:30  SQL Data In: ORACLE - Param = 124, Name = AS_YBSM14, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
687     10:14:30  SQL Data In: ORACLE - Param = 125, Name = AS_YBSM15, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
688     10:14:30  SQL Data In: ORACLE - Param = 126, Name = AS_YBSM16, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
689     10:14:30  SQL Data In: ORACLE - Param = 127, Name = AS_YBSM17, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
690     10:14:30  SQL Data In: ORACLE - Param = 128, Name = AS_YBSM18, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
691     10:14:30  SQL Data In: ORACLE - Param = 129, Name = AS_YBSM19, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
692     10:14:30  SQL Data In: ORACLE - Param = 130, Name = AS_YBSM20, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
693     10:14:30  SQL Data In: ORACLE - Param = 131, Name = AS_YBSM21, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
694     10:14:30  SQL Data In: ORACLE - Param = 132, Name = AS_YBSM22, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
695     10:14:30  SQL Data In: ORACLE - Param = 133, Name = AS_YBSM23, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
696     10:14:30  SQL Data In: ORACLE - Param = 134, Name = AS_YBSM24, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
697     10:14:30  SQL Data In: ORACLE - Param = 135, Name = AS_YBSM25, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
698     10:14:30  SQL Data In: ORACLE - Param = 136, Name = AS_YBSM26, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
699     10:14:30  SQL Data In: ORACLE - Param = 137, Name = AS_YBSM27, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
700     10:14:30  SQL Data In: ORACLE - Param = 138, Name = AS_YBSM28, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
701     10:14:30  SQL Data In: ORACLE - Param = 139, Name = AS_YBSM29, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
702     10:14:30  SQL Data In: ORACLE - Param = 140, Name = AS_MXLSH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
703     10:14:30  SQL Data In: ORACLE - Param = 141, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1721411.000000
704     10:14:30  SQL Data In: ORACLE - Param = 142, Name = AD_JSXZID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
705     10:14:30  SQL Data In: ORACLE - Param = 143, Name = AS_BYCS00, Type = fldZSTRING, Precision = 90, Scale = 0, Data = <JSQSRQ>20220307</JSQSRQ><JSJZRQ>20220408</JSJZRQ><MXSCBS>0</MXSCBS><YBJKTYPE>1</YBJKTYPE>
706     10:14:30  SQL Execute: ORACLE - BEGIN "SP_ZY_YBFSJG" (AD_ZYID00 => :AD_ZYID00,AD_QSDJH0 => :AD_QSDJH0,AD_ZZDJH0 => :AD_ZZDJH0,AS_YBFSDH => :AS_YBFSDH,AD_GRZFE0 => :AD_GRZFE0,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_SBGRZH => :AD_SBGRZH,AD_SBTCJJ => :AD_SBTCJJ,AD_HJJE00 => :AD_HJJE00,AD_DBGRZF => :AD_DBGRZF,AD_GSJJZF => :AD_GSJJZF,AD_GSZFJE => :AD_GSZFJE,AD_FGSFY0 => :AD_FGSFY0,AD_BJJJZF => :AD_BJJJZF,AD_GWYBZ0 => :AD_GWYBZ0,AD_SYBXZF => :AD_SYBXZF,AD_FYBFY0 => :AD_FYBFY0,AD_YLZFJE => :AD_YLZFJE,AD_CFDXJE => :AD_CFDXJE,AD_SBZFE0 => :AD_SBZFE0,AD_BJZFE0 => :AD_BJZFE0,AD_GRZHYE => :AD_GRZHYE,AD_YPWQZF => :AD_YPWQZF,AD_YPBFZF => :AD_YPBFZF,AD_XMWQZF => :AD_XMWQZF,AD_XMBFZF => :AD_XMBFZF,AS_BJJBIE => :AS_BJJBIE,AS_YBJZRQ => :AS_YBJZRQ,AS_YBJZSJ => :AS_YBJZSJ,AS_TSBZBH => :AS_TSBZBH,AD_CFXMS0 => :AD_CFXMS0,AD_YEXM00 => :AD_YEXM00,AD_CZY000 => :AD_CZY000,AD_CZYKS0 => :AD_CZYKS0,OD_YBZFJE => :OD_YBZFJE,OD_YBZHZF => :OD_YBZHZF,OD_YBJJZF => :OD_YBJJZF,OD_YBQTZF => :OD_YBQTZF,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AD_YBYL01 => :AD_YBYL01,AD_YBYL02 => :AD_YBYL02,AD_YBYL03 => :AD_YBYL03,AD_YBYL04 => :AD_YBYL04,AD_YBYL05 => :AD_YBYL05,AD_YBYL06 => :AD_YBYL06,AD_YBYL07 => :AD_YBYL07,AD_YBYL08 => :AD_YBYL08,AD_YBYL09 => :AD_YBYL09,AD_YBYL10 => :AD_YBYL10,AD_YBYL11 => :AD_YBYL11,AD_YBYL12 => :AD_YBYL12,AD_YBYL13 => :AD_YBYL13,AD_YBYL14 => :AD_YBYL14,AD_YBYL15 => :AD_YBYL15,AD_YBYL16 => :AD_YBYL16,AD_YBYL17 => :AD_YBYL17,AD_YBYL18 => :AD_YBYL18,AD_YBYL19 => :AD_YBYL19,AD_YBYL20 => :AD_YBYL20,AD_YBYL21 => :AD_YBYL21,AD_YBYL22 => :AD_YBYL22,AD_YBYL23 => :AD_YBYL23,AD_YBYL24 => :AD_YBYL24,AD_YBYL25 => :AD_YBYL25,AD_YBYL26 => :AD_YBYL26,AD_YBYL27 => :AD_YBYL27,AD_YBYL28 => :AD_YBYL28,AD_YBYL29 => :AD_YBYL29,AD_YBYL30 => :AD_YBYL30,AD_YBYL31 => :AD_YBYL31,AD_YBYL32 => :AD_YBYL32,AD_YBYL33 => :AD_YBYL33,AD_YBYL34 => :AD_YBYL34,AD_YBYL35 => :AD_YBYL35,AD_YBYL36 => :AD_YBYL36,AD_YBYL37 => :AD_YBYL37,AD_YBYL38 => :AD_YBYL38,AD_YBYL39 => :AD_YBYL39,AD_YBYL40 => :AD_YBYL40,AD_YBYL41 => :AD_YBYL41,AD_YBYL42 => :AD_YBYL42,AD_YBYL43 => :AD_YBYL43,AD_YBYL44 => :AD_YBYL44,AD_YBYL45 => :AD_YBYL45,AD_YBYL46 => :AD_YBYL46,AD_YBYL47 => :AD_YBYL47,AD_YBYL48 => :AD_YBYL48,AD_YBYL49 => :AD_YBYL49,AD_YBYL50 => :AD_YBYL50,AD_YBYL51 => :AD_YBYL51,AD_YBYL52 => :AD_YBYL52,AD_YBYL53 => :AD_YBYL53,AD_YBYL54 => :AD_YBYL54,AD_YBYL55 => :AD_YBYL55,AD_YBYL56 => :AD_YBYL56,AD_YBYL57 => :AD_YBYL57,AD_YBYL58 => :AD_YBYL58,AD_YBYL59 => :AD_YBYL59,AD_YBYL60 => :AD_YBYL60,AD_YBYL61 => :AD_YBYL61,AD_YBYL62 => :AD_YBYL62,AD_YBYL63 => :AD_YBYL63,AD_YBYL64 => :AD_YBYL64,AD_YBYL65 => :AD_YBYL65,AD_YBYL66 => :AD_YBYL66,AD_YBYL67 => :AD_YBYL67,AD_YBYL68 => :AD_YBYL68,AD_YBYL69 => :AD_YBYL69,AS_YBSM01 => :AS_YBSM01,AS_YBSM02 => :AS_YBSM02,AS_YBSM03 => :AS_YBSM03,AS_YBSM04 => :AS_YBSM04,AS_YBSM05 => :AS_YBSM05,AS_YBSM06 => :AS_YBSM06,AS_YBSM07 => :AS_YBSM07,AS_YBSM08 => :AS_YBSM08,AS_YBSM09 => :AS_YBSM09,AS_YBSM10 => :AS_YBSM10,AS_YBSM11 => :AS_YBSM11,AS_YBSM12 => :AS_YBSM12,AS_YBSM13 => :AS_YBSM13,AS_YBSM14 => :AS_YBSM14,AS_YBSM15 => :AS_YBSM15,AS_YBSM16 => :AS_YBSM16,AS_YBSM17 => :AS_YBSM17,AS_YBSM18 => :AS_YBSM18,AS_YBSM19 => :AS_YBSM19,AS_YBSM20 => :AS_YBSM20,AS_YBSM21 => :AS_YBSM21,AS_YBSM22 => :AS_YBSM22,AS_YBSM23 => :AS_YBSM23,AS_YBSM24 => :AS_YBSM24,AS_YBSM25 => :AS_YBSM25,AS_YBSM26 => :AS_YBSM26,AS_YBSM27 => :AS_YBSM27,AS_YBSM28 => :AS_YBSM28,AS_YBSM29 => :AS_YBSM29,AS_MXLSH0 => :AS_MXLSH0,AD_ID0000 => :AD_ID0000,AD_JSXZID => :AD_JSXZID,AS_BYCS00 => :AS_BYCS00); END;
707     10:14:30  SQL Misc: ORACLE - Set stored procedure on or off
708     10:14:30  SQL Data In: ORACLE - Param = 1, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
709     10:14:30  SQL Data In: ORACLE - Param = 2, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
710     10:14:30  SQL Data In: ORACLE - Param = 3, Name = AS_JFDJHS, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
711     10:14:30  SQL Data In: ORACLE - Param = 4, Name = AS_JMYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
712     10:14:30  SQL Data In: ORACLE - Param = 5, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
713     10:14:30  SQL Data In: ORACLE - Param = 6, Name = AS_JSZZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220408
714     10:14:30  SQL Data In: ORACLE - Param = 7, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
715     10:14:30  SQL Data In: ORACLE - Param = 8, Name = AD_YEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部
716     10:14:30  SQL Data In: ORACLE - Param = 9, Name = AD_DBZBM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
717     10:14:30  SQL Data In: ORACLE - Param = 10, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
718     10:14:30  SQL Data In: ORACLE - Param = 11, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
719     10:14:30  SQL Data In: ORACLE - Param = 12, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
720     10:14:30  SQL Data In: ORACLE - Param = 13, Name = AD_XJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
721     10:14:30  SQL Data In: ORACLE - Param = 14, Name = AD_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
722     10:14:30  SQL Data In: ORACLE - Param = 15, Name = AD_XJTKPJ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
723     10:14:30  SQL Data In: ORACLE - Param = 16, Name = AD_ZZTKPJ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
724     10:14:30  SQL Data In: ORACLE - Param = 17, Name = AS_XJTKXH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
725     10:14:30  SQL Data In: ORACLE - Param = 18, Name = AS_ZZTKXH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
726     10:14:30  SQL Data In: ORACLE - Param = 19, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
727     10:14:30  SQL Data In: ORACLE - Param = 20, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
728     10:14:30  SQL Data In: ORACLE - Param = 21, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
729     10:14:30  SQL Data In: ORACLE - Param = 22, Name = PCSLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
730     10:14:30  SQL Data In: ORACLE - Param = 23, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
731     10:14:30  SQL Data In: ORACLE - Param = 24, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
732     10:14:30  SQL Data In: ORACLE - Param = 25, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
733     10:14:30  SQL Data In: ORACLE - Param = 26, Name = AS_DDLSH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
734     10:14:30  SQL Data In: ORACLE - Param = 27, Name = AD_XJCXJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
735     10:14:30  SQL Data In: ORACLE - Param = 28, Name = AD_XJCXDJ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
736     10:14:30  SQL Data In: ORACLE - Param = 29, Name = AD_XJCXPJ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
737     10:14:30  SQL Data In: ORACLE - Param = 30, Name = AS_XJCXXH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
738     10:14:30  SQL Data In: ORACLE - Param = 31, Name = AD_CYQKJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
739     10:14:30  SQL Data In: ORACLE - Param = 32, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1721411.000000
740     10:14:30  SQL Data In: ORACLE - Param = 33, Name = AD_CYZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
741     10:14:30  SQL Data In: ORACLE - Param = 34, Name = AD_JSXZID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
742     10:14:30  SQL Data In: ORACLE - Param = 35, Name = AD_BYCS00, Type = fldZSTRING, Precision = 108, Scale = 0, Data = <JSQSRQ>20220307</JSQSRQ><JSJZRQ>20220408</JSJZRQ><MXSCBS>0</MXSCBS><YBJKTYPE>1</YBJKTYPE><BJTDJH>0</BJTDJH>
743     10:14:30  SQL Execute: ORACLE - BEGIN "SP_ZY_BRFY00_JS0000" (AD_ZYID00 => :AD_ZYID00,AD_JFLBID => :AD_JFLBID,AS_JFDJHS => :AS_JFDJHS,AS_JMYY00 => :AS_JMYY00,AS_CZBZ00 => :AS_CZBZ00,AS_JSZZRQ => :AS_JSZZRQ,AS_TSBZBH => :AS_TSBZBH,AD_YEXM00 => :AD_YEXM00,AD_DBZBM0 => :AD_DBZBM0,AD_JZDH00 => :AD_JZDH00,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_XJDJH0 => :AD_XJDJH0,AD_ZZDJH0 => :AD_ZZDJH0,AD_XJTKPJ => :AD_XJTKPJ,AD_ZZTKPJ => :AD_ZZTKPJ,AS_XJTKXH => :AS_XJTKXH,AS_ZZTKXH => :AS_ZZTKXH,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PCSLX00 => :PCSLX00,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,AS_DDLSH0 => :AS_DDLSH0,AD_XJCXJE => :AD_XJCXJE,AD_XJCXDJ => :AD_XJCXDJ,AD_XJCXPJ => :AD_XJCXPJ,AS_XJCXXH => :AS_XJCXXH,AD_CYQKJE => :AD_CYQKJE,AD_ID0000 => :AD_ID0000,AD_CYZT00 => :AD_CYZT00,AD_JSXZID => :AD_JSXZID,AD_BYCS00 => :AD_BYCS00); END;
744     10:14:32  SQL Execute: ORACLE - Rollback

745     10:14:32  SQL Data In: ORACLE - Rows affected = 0
746     10:14:34  SQL Execute: ORACLE - select YBJKID from ZY_YBFS00 where ZYID00=927436.00 and YBFSDH='245887' and JZDH00=0 and rownum=1 order by FSRQ00||FSSJ00 desc

747     10:14:34  SQL Execute: ORACLE - select * from VW_ZY_JZB000 where ZYID00 = 927436.00 and YBDJH0 = '245887'

748     10:14:58  SQL Misc: ORACLE - Set stored procedure on or off
749     10:14:58  SQL Data In: ORACLE - Param = 1, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
750     10:14:58  SQL Data In: ORACLE - Param = 2, Name = PYBFSDH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 245887
751     10:14:58  SQL Data In: ORACLE - Param = 3, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
752     10:14:58  SQL Data In: ORACLE - Param = 4, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
753     10:14:58  SQL Data In: ORACLE - Param = 5, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
754     10:14:58  SQL Data In: ORACLE - Param = 6, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
755     10:14:58  SQL Data In: ORACLE - Param = 7, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
756     10:14:58  SQL Data In: ORACLE - Param = 8, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
757     10:14:58  SQL Data In: ORACLE - Param = 9, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
758     10:14:58  SQL Execute: ORACLE - BEGIN "SP_ZY_YBFSJG_CX0000" (PZYID00 => :PZYID00,PYBFSDH => :PYBFSDH,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PJZDH00 => :PJZDH00); END;
759     10:15:00  SQL Execute: ORACLE - select JKLXBM,JKLXMC from VW_ZY_KSJSJKLX order by JKLXBM

760     10:15:00  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'Open_ZY'

761     10:15:00  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'Open_MZ'

762     10:15:00  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'JKQYSQM'

763     10:15:00  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'SFJYSZFW'

764     10:15:00  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'CYJSZFYM'

765     10:15:00  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '支付统一平台参数' and BH0000 = 'ZYYJJSTDJDYZFFS'

766     10:15:00  SQL Execute: ORACLE - select * from  VW_BM_BRZFFS where MZZYBZ in ('0','2') order by XSXH00

767     10:15:00  SQL Execute: ORACLE - select * from  BM_YHKDM0 where SFYX00 = '1' order by XSXH00

768     10:15:00  SQL Execute: ORACLE - select * from  BM_YHKDM0 where SFYX00 = '1' order by XSXH00

769     10:15:00  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS'

770     10:15:00  SQL Execute: ORACLE - select nvl(sum(JFJE00),0) JFZJE0 from VW_ZY_BRJFB0 where ZYID00 = -1.00 and PLBH00 in (4,8) 

771     10:15:00  SQL Execute: ORACLE - select nvl(sum(HJJE00),0) HJJE00 from VW_ZY_FYMX00 where ZYID00 = -1.00 

772     10:15:00  SQL Execute: ORACLE - select sysdate from dual

773     10:15:00  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

774     10:15:00  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

775     10:15:00  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00

776     10:15:00  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

777     10:15:00  SQL Execute: ORACLE - select nvl(sum(JFJE00),0) JFZJE0 from VW_ZY_BRJFB0 where ZYID00 = 927436.00 and PLBH00 in (4,8) 

778     10:15:00  SQL Execute: ORACLE - select nvl(sum(HJJE00),0) HJJE00 from VW_ZY_FYMX00 where ZYID00 = 927436.00 

779     10:15:00  SQL Execute: ORACLE - select sysdate from dual

780     10:15:00  SQL Execute: ORACLE - select * from VW_ZY_WSFYMX where ZYID00 = 927436.00 and KDRQ00 <= '20220408' order by SFYP00,ZXKSBH,XMBH00

781     10:15:00  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

782     10:15:00  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

783     10:15:00  SQL Execute: ORACLE - select MC0000 from BM_TYZD00 where ZDMC00 ='住院医院结算银行可填支付方式' and YXBZ00='1'

784     10:15:02  SQL Execute: ORACLE - select * from BM_BRZFFS where ZFFSBH in (2,8,18) 

785     10:15:02  SQL Misc: ORACLE - Set stored procedure on or off
786     10:15:02  SQL Data In: ORACLE - Param = 1, Name = PPJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
787     10:15:02  SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
788     10:15:02  SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
789     10:15:02  SQL Data In: ORACLE - Param = 4, Name = PPJXH00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 65101
790     10:15:02  SQL Data In: ORACLE - Param = 5, Name = PPLBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000
791     10:15:02  SQL Data In: ORACLE - Param = 6, Name = PYXSYBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
792     10:15:02  SQL Data In: ORACLE - Param = 7, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
793     10:15:02  SQL Data In: ORACLE - Param = 8, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
794     10:15:02  SQL Execute: ORACLE - BEGIN "SP_ZY_PJSYQK_PJSYJC" (PPJH000 => :PPJH000,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PPJXH00 => :PPJXH00,PPLBH00 => :PPLBH00,PYXSYBZ => :PYXSYBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END;
795     10:15:02  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

796     10:15:02  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

797     10:15:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付
798     10:15:02  SQL Execute: ORACLE -  select * from bm_brzffs where ZFFSMC=?

799     10:15:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
800     10:15:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金
801     10:15:02  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
802     10:15:02  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
803     10:15:02  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 24
804     10:15:02  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付
805     10:15:02  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
806     10:15:02  SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
807     10:15:02  SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
808     10:15:02  SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
809     10:15:02  SQL Execute: ORACLE - Select  SF_ZY_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00  from dual

810     10:15:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
811     10:15:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金
812     10:15:02  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
813     10:15:02  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
814     10:15:02  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 24
815     10:15:02  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付
816     10:15:02  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
817     10:15:02  SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
818     10:15:02  SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
819     10:15:02  SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
820     10:15:02  SQL Execute: ORACLE - Select  SF_ZY_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00  from dual

821     10:15:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
822     10:15:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金
823     10:15:02  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
824     10:15:02  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
825     10:15:02  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 24
826     10:15:02  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付
827     10:15:02  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
828     10:15:02  SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
829     10:15:02  SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
830     10:15:02  SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5
831     10:15:02  SQL Execute: ORACLE - Select  SF_ZY_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00  from dual

832     10:15:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
833     10:15:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金
834     10:15:02  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
835     10:15:02  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
836     10:15:02  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 24
837     10:15:02  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付
838     10:15:02  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
839     10:15:02  SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
840     10:15:02  SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
841     10:15:02  SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 6
842     10:15:02  SQL Execute: ORACLE - Select  SF_ZY_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00  from dual

843     10:15:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
844     10:15:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 收预交金
845     10:15:02  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
846     10:15:02  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
847     10:15:02  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 24
848     10:15:02  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付
849     10:15:02  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
850     10:15:02  SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
851     10:15:02  SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
852     10:15:02  SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
853     10:15:02  SQL Execute: ORACLE - Select  SF_ZY_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00  from dual

854     10:15:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
855     10:15:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
856     10:15:02  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
857     10:15:02  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
858     10:15:02  SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 96.000000
859     10:15:02  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
860     10:15:02  SQL Execute: ORACLE - Select  SF_ZY_PAYSFZX(?,?,?,?,?,?)FHXX00  from dual

861     10:15:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
862     10:15:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
863     10:15:02  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
864     10:15:02  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
865     10:15:02  SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 96.000000
866     10:15:02  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
867     10:15:02  SQL Execute: ORACLE - Select  SF_ZY_PAYSFZX(?,?,?,?,?,?)FHXX00  from dual

868     10:15:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
869     10:15:02  SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 

870     10:15:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
871     10:15:02  SQL Execute: ORACLE - Select *  from bm_ygbm00 where YGBH00=?

872     10:15:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
873     10:15:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4250243.000000
874     10:15:02  SQL Execute: ORACLE - select a.*,b.*  from bm_brxxb0 a,zy_brxxb0 b where a.brid00=b.brid00 and  b.zyid00=?
 and b.brid00=?

875     10:15:02  SQL Misc: ORACLE - Set stored procedure on or off
876     10:15:02  SQL Data In: ORACLE - Param = 1, Name = PJKLXBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
877     10:15:02  SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4250243.000000
878     10:15:02  SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
879     10:15:02  SQL Data In: ORACLE - Param = 4, Name = PZYHGHH, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2201812
880     10:15:02  SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
881     10:15:02  SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 刘和琴
882     10:15:02  SQL Data In: ORACLE - Param = 7, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
883     10:15:02  SQL Data In: ORACLE - Param = 8, Name = PJFBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
884     10:15:02  SQL Data In: ORACLE - Param = 9, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
885     10:15:02  SQL Data In: ORACLE - Param = 10, Name = PYJDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
886     10:15:02  SQL Data In: ORACLE - Param = 11, Name = PZFFS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 24.000000
887     10:15:02  SQL Data In: ORACLE - Param = 12, Name = PZFFSMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 微信支付
888     10:15:02  SQL Data In: ORACLE - Param = 13, Name = PJFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 96.000000
889     10:15:02  SQL Data In: ORACLE - Param = 14, Name = PFKTM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
890     10:15:02  SQL Data In: ORACLE - Param = 15, Name = PTKDDH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
891     10:15:02  SQL Data In: ORACLE - Param = 16, Name = PINCS00, Type = fldZSTRING, Precision = 80, Scale = 0, Data = 65101||||927436|收预交金|微信支付|96.00|0|N||20220408101502||494|bke284:|sfcye0:
892     10:15:02  SQL Data In: ORACLE - Param = 17, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
893     10:15:02  SQL Data In: ORACLE - Param = 18, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
894     10:15:02  SQL Data In: ORACLE - Param = 19, Name = PDDLSH0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
895     10:15:02  SQL Data In: ORACLE - Param = 20, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
896     10:15:02  SQL Execute: ORACLE - BEGIN "SP_SF_PAY_ZFRZ00" (PJKLXBH => :PJKLXBH,PBRID00 => :PBRID00,PZYGHID => :PZYGHID,PZYHGHH => :PZYHGHH,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PMZZYBZ => :PMZZYBZ,PJFBZ00 => :PJFBZ00,PJZDH00 => :PJZDH00,PYJDH00 => :PYJDH00,PZFFS00 => :PZFFS00,PZFFSMC => :PZFFSMC,PJFJE00 => :PJFJE00,PFKTM00 => :PFKTM00,PTKDDH0 => :PTKDDH0,PINCS00 => :PINCS00,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PDDLSH0 => :PDDLSH0,PERRMSG => :PERRMSG); END;
897     10:15:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
898     10:15:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
899     10:15:02  SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual

900     10:15:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
901     10:15:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
902     10:15:02  SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual

903     10:15:02  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
904     10:15:02  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
905     10:15:02  SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual

906     10:15:02  SQL Execute: ORACLE - COMMIT

907     10:15:03  SQL Data In: ORACLE - Rows affected = 0
908     10:15:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
909     10:15:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
910     10:15:03  SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual

911     10:15:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
912     10:15:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
913     10:15:03  SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual

914     10:15:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202204081015020443
915     10:15:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = param
916     10:15:03  SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? order by MXID00

917     10:15:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202204081015020443
918     10:15:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = extra
919     10:15:03  SQL Execute: ORACLE - Select * from BM_ZFRZMX where DDLSH0=? and CSLXMC=? order by MXID00

920     10:15:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 22.000000
921     10:15:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
922     10:15:03  SQL Execute: ORACLE - Select SF_SF_PAY_JKLXMC(?,?)FHXX00 from dual

923     10:15:03  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 255, Scale = 0, Data = {"transType":"hop.trade.setinfo","param":{"serveraddr":"http://10.88.88.119:8060/onepay-web/oneweb/oneapi","appid":"1BQTVVAVF0047501A8C000006D5AEBAA","appsecret":"1BQTVVAVB00A7501A8C000002FD0DCFF"},"notes":"22|0|65101||||927436|收预交金|微信支付|96.00|0|N
924     10:15:03  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202204081015020443
925     10:15:03  SQL Execute: ORACLE - update BM_ZFRZ00 set INCS00=? where DDLSH0=?

926     10:15:03  SQL Data In: ORACLE - Rows affected = 1
927     10:15:03  SQL Execute: ORACLE - COMMIT

928     10:15:03  SQL Data In: ORACLE - Rows affected = 0
929     10:15:24  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 000000
930     10:15:24  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付成功交易成功
931     10:15:24  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202204081015020443
932     10:15:24  SQL Execute: ORACLE - update BM_ZFRZ00 set OUTCS0=?,JKXYBM=?,JKXYXX=? where DDLSH0=?

933     10:15:24  SQL Data In: ORACLE - Rows affected = 1
934     10:15:24  SQL Execute: ORACLE - COMMIT

935     10:15:24  SQL Data In: ORACLE - Rows affected = 0
936     10:15:24  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4250243.000000
937     10:15:24  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = ZY202204081015020443
938     10:15:24  SQL Execute: ORACLE -  select * from BM_ZFRZ00 where BRID00=? and DDLSH0=?

939     10:15:24  SQL Execute: ORACLE - select PJH000 from ZY_BRJFB0 where DJH000 = 39999554.00

940     10:15:24  SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='博思预交金电子凭证平台接口' 

941     10:15:24  SQL Execute: ORACLE - select nvl(max(PJXH00),'0') PJXH00 from ZY_PJSYQK where PJH000 = 2249403.00

942     10:15:25  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2249403
943     10:15:25  SQL Execute: ORACLE - select * from VW_ZY_YJJPJ0_NEW where PJH000 = ? 

944     10:15:25  SQL Execute: ORACLE - select 1241 as UserId,'100052' as UserCode,'刘和琴' as UserName,494 as UserLogDepId,'住院收费处' as UserLogDepName, '5' as UserLogSysCode,'住院收费管理系统' as UserLogSysName,'220035' as HospitalCode,'福建省老年医院' as HospitalName, '220035' as UserLogDepYYID,'福建省老年医院' as UserLogDepYYMC  from dual 

945     10:15:26  SQL Execute: ORACLE - select nvl(sum(JFJE00),0) JFZJE0 from VW_ZY_BRJFB0 where ZYID00 = -1.00 and PLBH00 in (4,8) 

946     10:15:26  SQL Execute: ORACLE - select nvl(sum(HJJE00),0) HJJE00 from VW_ZY_FYMX00 where ZYID00 = -1.00 

947     10:15:26  SQL Execute: ORACLE - select sysdate from dual

948     10:15:26  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

949     10:15:26  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

950     10:15:26  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

951     10:15:27  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00

952     10:15:27  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

953     10:15:27  SQL Execute: ORACLE - select sysdate from dual

954     10:15:27  SQL Execute: ORACLE - select distinct nvl(YEXM00,'全部') as YEXM00 from VW_ZY_FYMX00 where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00<= '20220408' 

955     10:15:27  SQL Execute: ORACLE - select 0 as XZ0000,a.* from VW_ZY_FYMX00 a where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' order by MXID00

956     10:15:27  SQL Execute: ORACLE - select * from VW_ZY_WSFYMX where ZYID00 = 927436.00 and KDRQ00 <= '20220408' order by SFYP00,ZXKSBH,XMBH00

957     10:15:27  SQL Execute: ORACLE - select * from VW_ZY_BRJFB0 where ZYID00 = 927436.00 and JZDH00+0 = 0 and PLBH00 in (4,8) order by DJH000

958     10:15:27  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0_EXT where BRID00 = 4250243.00 and ZYID00<> 927436.00 order by ZYID00 desc 

959     10:15:27  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00 

960     10:15:27  SQL Execute: ORACLE - select ZYFPID,ZYFPMC,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from VW_ZY_FYMX00  where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' group by ZYFPID,ZYFPMC

961     10:15:27  SQL Execute: ORACLE - select ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH,sum(XMSL00) XMSL00,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from  VW_ZY_FYMX00   where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' group by ZYFPID,ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH

962     10:15:28  SQL Execute: ORACLE - select * from VW_ZY_JZB000 where ZYID00 = 927436.00 order by JZDH00

963     10:15:28  SQL Execute: ORACLE - select * from VW_ZY_YZYPSQ_WQY where ZYID00 = 927436.00 and SRRQ00 <= '20220408' order by SRRQ00,SRSJ00 

964     10:15:28  SQL Execute: ORACLE - select a.* from VW_ZY_YJTFMX_WZX a where a.ZYID00 = 927436.00   and a.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b where b.ZYGHID = a.ZYID00  and b.SFDJH0 in ( select c.DJH000 from ZY_FYMX00 c where c.ZYID00=a.ZYID00 and c.JZDH00+0 = 0 and c.CZRQ00<= '20220408') )  order by a.KDRQ00 desc 

965     10:15:28  SQL Execute: ORACLE - select a.* from VW_ZY_YPTFMX_WZX a where a.ZYID00 = 927436.00   and a.CXPCID in (select YPQLPC from  YF_YZYPSQ e,ZY_FYMX00 f where e.DJH000 = f.DJH000 and f.JZDH00+0 = 0     and f.ZYID00=a.ZYID00 and f.CZRQ00 <= '20220408')  order by a.SRRQ00  desc 

966     10:15:28  SQL Execute: ORACLE - select * from VW_BQ_BRZDXX where ZYID00 = 927436.00 order by ZDRQ00,ZDSJ00

967     10:15:28  SQL Execute: ORACLE - select nvl(sum(NVL(HJJE00,0)),0) HJJE00, nvl(sum(NVL(ZFJE00,0)),0) ZFJE00, nvl(sum(NVL(JZJE00,0)),0) JZJE00, nvl(sum(NVL(GFJE00,0)),0) GFJE00, nvl(sum(nvl(JMJE00,0)),0) JMJE00, nvl(min(DJH000),0) QSDJH0,nvl(max(DJH000),0) ZZDJH0,   nvl(max(YEXM00),'全部') YEXM00, nvl(min(QDRQ00),'19000101') JSQSRQ, nvl(max(QDRQ00),'20220408') JSJZRQ from VW_ZY_FYMX00 where JZDH00+0 = 0 and JFLBID = 2 and ZYID00 = 927436.00 and CZRQ00<= '20220408'

968     10:15:28  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

969     10:15:28  SQL Execute: ORACLE - select max(JSJZRQ) SCJSRQ from ZY_JZB000  where ZYID00=927436.00 and JZZT00='0' and JSLX00='0'  and nvl(CXJZDH,0)=0 and nvl(YEXM00,'全部') in ('全部','婴儿')

970     10:15:28  SQL Execute: ORACLE - RollBack

971     10:15:28  SQL Data In: ORACLE - Rows affected = 0
972     10:15:28  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

973     10:15:28  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00

974     10:15:28  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

975     10:15:28  SQL Execute: ORACLE - select sysdate from dual

976     10:15:28  SQL Execute: ORACLE - select distinct nvl(YEXM00,'全部') as YEXM00 from VW_ZY_FYMX00 where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00<= '20220408' 

977     10:15:28  SQL Execute: ORACLE - select 0 as XZ0000,a.* from VW_ZY_FYMX00 a where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' order by MXID00

978     10:15:29  SQL Execute: ORACLE - select * from VW_ZY_WSFYMX where ZYID00 = 927436.00 and KDRQ00 <= '20220408' order by SFYP00,ZXKSBH,XMBH00

979     10:15:29  SQL Execute: ORACLE - select * from VW_ZY_BRJFB0 where ZYID00 = 927436.00 and JZDH00+0 = 0 and PLBH00 in (4,8) order by DJH000

980     10:15:29  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0_EXT where BRID00 = 4250243.00 and ZYID00<> 927436.00 order by ZYID00 desc 

981     10:15:29  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00 

982     10:15:29  SQL Execute: ORACLE - select ZYFPID,ZYFPMC,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from VW_ZY_FYMX00  where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' group by ZYFPID,ZYFPMC

983     10:15:29  SQL Execute: ORACLE - select ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH,sum(XMSL00) XMSL00,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from  VW_ZY_FYMX00   where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' group by ZYFPID,ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH

984     10:15:29  SQL Execute: ORACLE - select * from VW_ZY_JZB000 where ZYID00 = 927436.00 order by JZDH00

985     10:15:29  SQL Execute: ORACLE - select * from VW_ZY_YZYPSQ_WQY where ZYID00 = 927436.00 and SRRQ00 <= '20220408' order by SRRQ00,SRSJ00 

986     10:15:29  SQL Execute: ORACLE - select a.* from VW_ZY_YJTFMX_WZX a where a.ZYID00 = 927436.00   and a.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b where b.ZYGHID = a.ZYID00  and b.SFDJH0 in ( select c.DJH000 from ZY_FYMX00 c where c.ZYID00=a.ZYID00 and c.JZDH00+0 = 0 and c.CZRQ00<= '20220408') )  order by a.KDRQ00 desc 

987     10:15:29  SQL Execute: ORACLE - select a.* from VW_ZY_YPTFMX_WZX a where a.ZYID00 = 927436.00   and a.CXPCID in (select YPQLPC from  YF_YZYPSQ e,ZY_FYMX00 f where e.DJH000 = f.DJH000 and f.JZDH00+0 = 0     and f.ZYID00=a.ZYID00 and f.CZRQ00 <= '20220408')  order by a.SRRQ00  desc 

988     10:15:29  SQL Execute: ORACLE - select * from VW_BQ_BRZDXX where ZYID00 = 927436.00 order by ZDRQ00,ZDSJ00

989     10:15:29  SQL Execute: ORACLE - select nvl(sum(NVL(HJJE00,0)),0) HJJE00, nvl(sum(NVL(ZFJE00,0)),0) ZFJE00, nvl(sum(NVL(JZJE00,0)),0) JZJE00, nvl(sum(NVL(GFJE00,0)),0) GFJE00, nvl(sum(nvl(JMJE00,0)),0) JMJE00, nvl(min(DJH000),0) QSDJH0,nvl(max(DJH000),0) ZZDJH0,   nvl(max(YEXM00),'全部') YEXM00, nvl(min(QDRQ00),'19000101') JSQSRQ, nvl(max(QDRQ00),'20220408') JSJZRQ from VW_ZY_FYMX00 where JZDH00+0 = 0 and JFLBID = 2 and ZYID00 = 927436.00 and CZRQ00<= '20220408'

990     10:15:29  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

991     10:15:29  SQL Execute: ORACLE - select max(JSJZRQ) SCJSRQ from ZY_JZB000  where ZYID00=927436.00 and JZZT00='0' and JSLX00='0'  and nvl(CXJZDH,0)=0 and nvl(YEXM00,'全部') in ('全部','婴儿')

992     10:15:30  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

993     10:15:31  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00

994     10:15:31  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

995     10:15:31  SQL Execute: ORACLE - select sysdate from dual

996     10:15:31  SQL Execute: ORACLE - select distinct nvl(YEXM00,'全部') as YEXM00 from VW_ZY_FYMX00 where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00<= '20220408' 

997     10:15:31  SQL Execute: ORACLE - select 0 as XZ0000,a.* from VW_ZY_FYMX00 a where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' order by MXID00

998     10:15:31  SQL Execute: ORACLE - select * from VW_ZY_WSFYMX where ZYID00 = 927436.00 and KDRQ00 <= '20220408' order by SFYP00,ZXKSBH,XMBH00

999     10:15:31  SQL Execute: ORACLE - select * from VW_ZY_BRJFB0 where ZYID00 = 927436.00 and JZDH00+0 = 0 and PLBH00 in (4,8) order by DJH000

1000    10:15:31  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0_EXT where BRID00 = 4250243.00 and ZYID00<> 927436.00 order by ZYID00 desc 

1001    10:15:31  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00 

1002    10:15:31  SQL Execute: ORACLE - select ZYFPID,ZYFPMC,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from VW_ZY_FYMX00  where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' group by ZYFPID,ZYFPMC

1003    10:15:31  SQL Execute: ORACLE - select ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH,sum(XMSL00) XMSL00,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from  VW_ZY_FYMX00   where ZYID00 = 927436.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' group by ZYFPID,ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH

1004    10:15:31  SQL Execute: ORACLE - select * from VW_ZY_JZB000 where ZYID00 = 927436.00 order by JZDH00

1005    10:15:31  SQL Execute: ORACLE - select * from VW_ZY_YZYPSQ_WQY where ZYID00 = 927436.00 and SRRQ00 <= '20220408' order by SRRQ00,SRSJ00 

1006    10:15:32  SQL Execute: ORACLE - select a.* from VW_ZY_YJTFMX_WZX a where a.ZYID00 = 927436.00   and a.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b where b.ZYGHID = a.ZYID00  and b.SFDJH0 in ( select c.DJH000 from ZY_FYMX00 c where c.ZYID00=a.ZYID00 and c.JZDH00+0 = 0 and c.CZRQ00<= '20220408') )  order by a.KDRQ00 desc 

1007    10:15:32  SQL Execute: ORACLE - select a.* from VW_ZY_YPTFMX_WZX a where a.ZYID00 = 927436.00   and a.CXPCID in (select YPQLPC from  YF_YZYPSQ e,ZY_FYMX00 f where e.DJH000 = f.DJH000 and f.JZDH00+0 = 0     and f.ZYID00=a.ZYID00 and f.CZRQ00 <= '20220408')  order by a.SRRQ00  desc 

1008    10:15:32  SQL Execute: ORACLE - select * from VW_BQ_BRZDXX where ZYID00 = 927436.00 order by ZDRQ00,ZDSJ00

1009    10:15:32  SQL Execute: ORACLE - select nvl(sum(NVL(HJJE00,0)),0) HJJE00, nvl(sum(NVL(ZFJE00,0)),0) ZFJE00, nvl(sum(NVL(JZJE00,0)),0) JZJE00, nvl(sum(NVL(GFJE00,0)),0) GFJE00, nvl(sum(nvl(JMJE00,0)),0) JMJE00, nvl(min(DJH000),0) QSDJH0,nvl(max(DJH000),0) ZZDJH0,   nvl(max(YEXM00),'全部') YEXM00, nvl(min(QDRQ00),'19000101') JSQSRQ, nvl(max(QDRQ00),'20220408') JSJZRQ from VW_ZY_FYMX00 where JZDH00+0 = 0 and JFLBID = 2 and ZYID00 = 927436.00 and CZRQ00<= '20220408'

1010    10:15:32  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

1011    10:15:32  SQL Execute: ORACLE - select max(JSJZRQ) SCJSRQ from ZY_JZB000  where ZYID00=927436.00 and JZZT00='0' and JSLX00='0'  and nvl(CXJZDH,0)=0 and nvl(YEXM00,'全部') in ('全部','婴儿')

1012    10:15:32  SQL Misc: ORACLE - Set stored procedure on or off
1013    10:15:32  SQL Data In: ORACLE - Param = 1, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
1014    10:15:32  SQL Data In: ORACLE - Param = 2, Name = PJFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
1015    10:15:32  SQL Data In: ORACLE - Param = 3, Name = PCZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
1016    10:15:32  SQL Data In: ORACLE - Param = 4, Name = PJSZZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220408
1017    10:15:32  SQL Data In: ORACLE - Param = 5, Name = PYEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部
1018    10:15:32  SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
1019    10:15:32  SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
1020    10:15:32  SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
1021    10:15:32  SQL Data In: ORACLE - Param = 9, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1022    10:15:32  SQL Data In: ORACLE - Param = 10, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
1023    10:15:32  SQL Data In: ORACLE - Param = 11, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
1024    10:15:32  SQL Execute: ORACLE - BEGIN "SP_ZY_FYJS00_TSXZ00" (PZYID00 => :PZYID00,PJFLBID => :PJFLBID,PCZBZ00 => :PCZBZ00,PJSZZRQ => :PJSZZRQ,PYEXM00 => :PYEXM00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END;
1025    10:15:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'JSSFFSYBXXZGCX'

1026    10:15:32  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'JSSFFSYBXXZGCX'

1027    10:15:32  SQL Execute: ORACLE - select count(*) from ZY_FYMX00 where ZYID00=927436.00 and YBFSDH='0'

1028    10:15:33  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
1029    10:15:33  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1030    10:15:33  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1031    10:15:33  SQL Execute: ORACLE - select SF_ZY_GETSFTCSRPTBCTS(?,?,?) SFTCSR from dual

1032    10:15:33  SQL Execute: ORACLE - select YBKSBH from VW_BM_BMBM00 where BMBH00 = 491

1033    10:15:33  SQL Execute: ORACLE - select count(*) ZJL from ZY_YBFS00 where ZYID00 = 927436.00 and CXBZ00<>'1' 

1034    10:15:33  SQL Misc: ORACLE - Set stored procedure on or off
1035    10:15:33  SQL Data In: ORACLE - Param = 1, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1036    10:15:33  SQL Data In: ORACLE - Param = 2, Name = AS_QSRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1037    10:15:33  SQL Data In: ORACLE - Param = 3, Name = AS_ZZRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1038    10:15:33  SQL Data In: ORACLE - Param = 4, Name = AS_YBMC00, Type = fldZSTRING, Precision = 14, Scale = 0, Data = 福建省两费中心
1039    10:15:33  SQL Data In: ORACLE - Param = 5, Name = AS_CLJKGC, Type = fldZSTRING, Precision = 19, Scale = 0, Data = SP_ZY_ZYSF00_YBJK01
1040    10:15:33  SQL Data In: ORACLE - Param = 6, Name = AD_YEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部
1041    10:15:33  SQL Data In: ORACLE - Param = 7, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
1042    10:15:33  SQL Data In: ORACLE - Param = 8, Name = AD_QSDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39559875.000000
1043    10:15:33  SQL Data In: ORACLE - Param = 9, Name = AD_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39999323.000000
1044    10:15:33  SQL Data In: ORACLE - Param = 10, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1045    10:15:33  SQL Data In: ORACLE - Param = 11, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
1046    10:15:33  SQL Execute: ORACLE - BEGIN "SP_ZY_WSPYPTS" (AD_JZDH00 => :AD_JZDH00,AS_QSRQ00 => :AS_QSRQ00,AS_ZZRQ00 => :AS_ZZRQ00,AS_YBMC00 => :AS_YBMC00,AS_CLJKGC => :AS_CLJKGC,AD_YEXM00 => :AD_YEXM00,AD_ZYID00 => :AD_ZYID00,AD_QSDJH0 => :AD_QSDJH0,AD_ZZDJH0 => :AD_ZZDJH0,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END;
1047    10:15:33  SQL Misc: ORACLE - Set stored procedure on or off
1048    10:15:33  SQL Data In: ORACLE - Param = 1, Name = AD_QSDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39559875.000000
1049    10:15:33  SQL Data In: ORACLE - Param = 2, Name = AD_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39999323.000000
1050    10:15:33  SQL Data In: ORACLE - Param = 3, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1051    10:15:33  SQL Data In: ORACLE - Param = 4, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
1052    10:15:33  SQL Data In: ORACLE - Param = 5, Name = AS_QSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220307
1053    10:15:33  SQL Data In: ORACLE - Param = 6, Name = AS_ZZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220408
1054    10:15:33  SQL Data In: ORACLE - Param = 7, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1055    10:15:33  SQL Data In: ORACLE - Param = 8, Name = AS_FLAG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
1056    10:15:33  SQL Data In: ORACLE - Param = 9, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
1057    10:15:33  SQL Data In: ORACLE - Param = 10, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
1058    10:15:33  SQL Data In: ORACLE - Param = 11, Name = AD_YEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部
1059    10:15:33  SQL Data In: ORACLE - Param = 12, Name = AD_SFXYB0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
1060    10:15:33  SQL Data In: ORACLE - Param = 13, Name = AD_JSXZID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1061    10:15:33  SQL Data In: ORACLE - Param = 14, Name = AS_INXML0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1062    10:15:33  SQL Execute: ORACLE - BEGIN "SP_ZY_YBJK00_FJ0000" (AD_QSDJH0 => :AD_QSDJH0,AD_ZZDJH0 => :AD_ZZDJH0,AD_JZDH00 => :AD_JZDH00,AD_ZYID00 => :AD_ZYID00,AS_QSRQ00 => :AS_QSRQ00,AS_ZZRQ00 => :AS_ZZRQ00,AD_ID0000 => :AD_ID0000,AS_FLAG00 => :AS_FLAG00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AD_YEXM00 => :AD_YEXM00,AD_SFXYB0 => :AD_SFXYB0,AD_JSXZID => :AD_JSXZID,AS_INXML0 => :AS_INXML0); END;
1063    10:15:34  SQL Execute: ORACLE - select SF_ZY_FSDYLX(0,'福建省两费中心') as FSDYLX from dual

1064    10:15:34  SQL Execute: ORACLE - select  *  from  VW_ZY_XMFSDY where MRFS00 = '1' order by PXXH00

1065    10:15:34  SQL Execute: ORACLE - select  *  from  BM_ZYCF00_TEMP00  where ID0000 = 1721413.00  

1066    10:15:34  SQL Execute: ORACLE - select  *  from  BM_ZYCFMX_TEMP00  where ID0000 = 1721413.00  

1067    10:15:34  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

1068    10:15:34  SQL Execute: ORACLE - update ZY_BRXXB0 set YBJHBZ ='1' where ZYID00 = 927436.00

1069    10:15:34  SQL Data In: ORACLE - Rows affected = 1
1070    10:15:34  SQL Execute: ORACLE - Commit

1071    10:15:34  SQL Data In: ORACLE - Rows affected = 0
1072    10:16:03  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'yyyy-MM-dd') OraSysDate FROM DUAL

1073    10:16:03  SQL Execute: ORACLE - update ZY_BRXXB0 set YBJHBZ ='2' where ZYID00 = 927436.00

1074    10:16:03  SQL Data In: ORACLE - Rows affected = 1
1075    10:16:03  SQL Execute: ORACLE - Commit

1076    10:16:03  SQL Data In: ORACLE - Rows affected = 0
1077    10:16:03  SQL Misc: ORACLE - Set stored procedure on or off
1078    10:16:03  SQL Data In: ORACLE - Param = 1, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
1079    10:16:03  SQL Data In: ORACLE - Param = 2, Name = AD_QSDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39559875.000000
1080    10:16:03  SQL Data In: ORACLE - Param = 3, Name = AD_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 39999323.000000
1081    10:16:03  SQL Data In: ORACLE - Param = 4, Name = AS_YBFSDH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 245889
1082    10:16:03  SQL Data In: ORACLE - Param = 5, Name = AD_GRZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 96.000000
1083    10:16:03  SQL Data In: ORACLE - Param = 6, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1084    10:16:03  SQL Data In: ORACLE - Param = 7, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30591.870000
1085    10:16:03  SQL Data In: ORACLE - Param = 8, Name = AD_SBGRZH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1086    10:16:03  SQL Data In: ORACLE - Param = 9, Name = AD_SBTCJJ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1087    10:16:03  SQL Data In: ORACLE - Param = 10, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30687.870000
1088    10:16:03  SQL Data In: ORACLE - Param = 11, Name = AD_DBGRZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1089    10:16:03  SQL Data In: ORACLE - Param = 12, Name = AD_GSJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1090    10:16:03  SQL Data In: ORACLE - Param = 13, Name = AD_GSZFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1091    10:16:03  SQL Data In: ORACLE - Param = 14, Name = AD_FGSFY0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1092    10:16:03  SQL Data In: ORACLE - Param = 15, Name = AD_BJJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1093    10:16:03  SQL Data In: ORACLE - Param = 16, Name = AD_GWYBZ0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1094    10:16:03  SQL Data In: ORACLE - Param = 17, Name = AD_SYBXZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1095    10:16:03  SQL Data In: ORACLE - Param = 18, Name = AD_FYBFY0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1096    10:16:03  SQL Data In: ORACLE - Param = 19, Name = AD_YLZFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1097    10:16:03  SQL Data In: ORACLE - Param = 20, Name = AD_CFDXJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1098    10:16:03  SQL Data In: ORACLE - Param = 21, Name = AD_SBZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1099    10:16:03  SQL Data In: ORACLE - Param = 22, Name = AD_BJZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1100    10:16:03  SQL Data In: ORACLE - Param = 23, Name = AD_GRZHYE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1101    10:16:03  SQL Data In: ORACLE - Param = 24, Name = AD_YPWQZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1102    10:16:03  SQL Data In: ORACLE - Param = 25, Name = AD_YPBFZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1103    10:16:03  SQL Data In: ORACLE - Param = 26, Name = AD_XMWQZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1104    10:16:03  SQL Data In: ORACLE - Param = 27, Name = AD_XMBFZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1105    10:16:03  SQL Data In: ORACLE - Param = 28, Name = AS_BJJBIE, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 04
1106    10:16:03  SQL Data In: ORACLE - Param = 29, Name = AS_YBJZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220408
1107    10:16:03  SQL Data In: ORACLE - Param = 30, Name = AS_YBJZSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 10:02:00
1108    10:16:03  SQL Data In: ORACLE - Param = 31, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1109    10:16:03  SQL Data In: ORACLE - Param = 32, Name = AD_CFXMS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1110    10:16:03  SQL Data In: ORACLE - Param = 33, Name = AD_YEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部
1111    10:16:03  SQL Data In: ORACLE - Param = 34, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
1112    10:16:03  SQL Data In: ORACLE - Param = 35, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
1113    10:16:03  SQL Data In: ORACLE - Param = 36, Name = OD_YBZFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1114    10:16:03  SQL Data In: ORACLE - Param = 37, Name = OD_YBZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1115    10:16:03  SQL Data In: ORACLE - Param = 38, Name = OD_YBJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1116    10:16:03  SQL Data In: ORACLE - Param = 39, Name = OD_YBQTZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1117    10:16:03  SQL Data In: ORACLE - Param = 40, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
1118    10:16:03  SQL Data In: ORACLE - Param = 41, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
1119    10:16:03  SQL Data In: ORACLE - Param = 42, Name = AD_YBYL01, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1120    10:16:03  SQL Data In: ORACLE - Param = 43, Name = AD_YBYL02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1121    10:16:03  SQL Data In: ORACLE - Param = 44, Name = AD_YBYL03, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1122    10:16:03  SQL Data In: ORACLE - Param = 45, Name = AD_YBYL04, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1123    10:16:03  SQL Data In: ORACLE - Param = 46, Name = AD_YBYL05, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1124    10:16:03  SQL Data In: ORACLE - Param = 47, Name = AD_YBYL06, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1125    10:16:03  SQL Data In: ORACLE - Param = 48, Name = AD_YBYL07, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1126    10:16:03  SQL Data In: ORACLE - Param = 49, Name = AD_YBYL08, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1127    10:16:03  SQL Data In: ORACLE - Param = 50, Name = AD_YBYL09, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1128    10:16:03  SQL Data In: ORACLE - Param = 51, Name = AD_YBYL10, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1129    10:16:03  SQL Data In: ORACLE - Param = 52, Name = AD_YBYL11, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1130    10:16:03  SQL Data In: ORACLE - Param = 53, Name = AD_YBYL12, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1131    10:16:03  SQL Data In: ORACLE - Param = 54, Name = AD_YBYL13, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1132    10:16:03  SQL Data In: ORACLE - Param = 55, Name = AD_YBYL14, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1133    10:16:03  SQL Data In: ORACLE - Param = 56, Name = AD_YBYL15, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1134    10:16:03  SQL Data In: ORACLE - Param = 57, Name = AD_YBYL16, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1135    10:16:03  SQL Data In: ORACLE - Param = 58, Name = AD_YBYL17, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1136    10:16:03  SQL Data In: ORACLE - Param = 59, Name = AD_YBYL18, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1137    10:16:03  SQL Data In: ORACLE - Param = 60, Name = AD_YBYL19, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1138    10:16:03  SQL Data In: ORACLE - Param = 61, Name = AD_YBYL20, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1139    10:16:03  SQL Data In: ORACLE - Param = 62, Name = AD_YBYL21, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1140    10:16:03  SQL Data In: ORACLE - Param = 63, Name = AD_YBYL22, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1141    10:16:03  SQL Data In: ORACLE - Param = 64, Name = AD_YBYL23, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1142    10:16:03  SQL Data In: ORACLE - Param = 65, Name = AD_YBYL24, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1143    10:16:03  SQL Data In: ORACLE - Param = 66, Name = AD_YBYL25, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1144    10:16:03  SQL Data In: ORACLE - Param = 67, Name = AD_YBYL26, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1145    10:16:03  SQL Data In: ORACLE - Param = 68, Name = AD_YBYL27, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1146    10:16:03  SQL Data In: ORACLE - Param = 69, Name = AD_YBYL28, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1147    10:16:03  SQL Data In: ORACLE - Param = 70, Name = AD_YBYL29, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1148    10:16:03  SQL Data In: ORACLE - Param = 71, Name = AD_YBYL30, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1149    10:16:03  SQL Data In: ORACLE - Param = 72, Name = AD_YBYL31, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 96.000000
1150    10:16:03  SQL Data In: ORACLE - Param = 73, Name = AD_YBYL32, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1151    10:16:03  SQL Data In: ORACLE - Param = 74, Name = AD_YBYL33, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1152    10:16:03  SQL Data In: ORACLE - Param = 75, Name = AD_YBYL34, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1153    10:16:03  SQL Data In: ORACLE - Param = 76, Name = AD_YBYL35, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30687.870000
1154    10:16:03  SQL Data In: ORACLE - Param = 77, Name = AD_YBYL36, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1155    10:16:03  SQL Data In: ORACLE - Param = 78, Name = AD_YBYL37, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1156    10:16:03  SQL Data In: ORACLE - Param = 79, Name = AD_YBYL38, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1157    10:16:03  SQL Data In: ORACLE - Param = 80, Name = AD_YBYL39, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1158    10:16:03  SQL Data In: ORACLE - Param = 81, Name = AD_YBYL40, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1159    10:16:03  SQL Data In: ORACLE - Param = 82, Name = AD_YBYL41, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1160    10:16:03  SQL Data In: ORACLE - Param = 83, Name = AD_YBYL42, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1161    10:16:03  SQL Data In: ORACLE - Param = 84, Name = AD_YBYL43, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1162    10:16:03  SQL Data In: ORACLE - Param = 85, Name = AD_YBYL44, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1163    10:16:03  SQL Data In: ORACLE - Param = 86, Name = AD_YBYL45, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1164    10:16:03  SQL Data In: ORACLE - Param = 87, Name = AD_YBYL46, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1165    10:16:03  SQL Data In: ORACLE - Param = 88, Name = AD_YBYL47, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1166    10:16:03  SQL Data In: ORACLE - Param = 89, Name = AD_YBYL48, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1167    10:16:03  SQL Data In: ORACLE - Param = 90, Name = AD_YBYL49, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1168    10:16:03  SQL Data In: ORACLE - Param = 91, Name = AD_YBYL50, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1169    10:16:03  SQL Data In: ORACLE - Param = 92, Name = AD_YBYL51, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1170    10:16:03  SQL Data In: ORACLE - Param = 93, Name = AD_YBYL52, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1171    10:16:03  SQL Data In: ORACLE - Param = 94, Name = AD_YBYL53, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1172    10:16:03  SQL Data In: ORACLE - Param = 95, Name = AD_YBYL54, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1173    10:16:03  SQL Data In: ORACLE - Param = 96, Name = AD_YBYL55, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1174    10:16:03  SQL Data In: ORACLE - Param = 97, Name = AD_YBYL56, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1175    10:16:03  SQL Data In: ORACLE - Param = 98, Name = AD_YBYL57, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1176    10:16:03  SQL Data In: ORACLE - Param = 99, Name = AD_YBYL58, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1177    10:16:03  SQL Data In: ORACLE - Param = 100, Name = AD_YBYL59, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1178    10:16:03  SQL Data In: ORACLE - Param = 101, Name = AD_YBYL60, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1179    10:16:03  SQL Data In: ORACLE - Param = 102, Name = AD_YBYL61, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1180    10:16:03  SQL Data In: ORACLE - Param = 103, Name = AD_YBYL62, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1181    10:16:03  SQL Data In: ORACLE - Param = 104, Name = AD_YBYL63, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1182    10:16:03  SQL Data In: ORACLE - Param = 105, Name = AD_YBYL64, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1183    10:16:03  SQL Data In: ORACLE - Param = 106, Name = AD_YBYL65, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1184    10:16:03  SQL Data In: ORACLE - Param = 107, Name = AD_YBYL66, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1185    10:16:03  SQL Data In: ORACLE - Param = 108, Name = AD_YBYL67, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1186    10:16:03  SQL Data In: ORACLE - Param = 109, Name = AD_YBYL68, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1187    10:16:03  SQL Data In: ORACLE - Param = 110, Name = AD_YBYL69, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1188    10:16:03  SQL Data In: ORACLE - Param = 111, Name = AS_YBSM01, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 本地
1189    10:16:03  SQL Data In: ORACLE - Param = 112, Name = AS_YBSM02, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1190    10:16:03  SQL Data In: ORACLE - Param = 113, Name = AS_YBSM03, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1191    10:16:03  SQL Data In: ORACLE - Param = 114, Name = AS_YBSM04, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1192    10:16:03  SQL Data In: ORACLE - Param = 115, Name = AS_YBSM05, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 245889
1193    10:16:03  SQL Data In: ORACLE - Param = 116, Name = AS_YBSM06, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1194    10:16:03  SQL Data In: ORACLE - Param = 117, Name = AS_YBSM07, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1195    10:16:03  SQL Data In: ORACLE - Param = 118, Name = AS_YBSM08, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1196    10:16:03  SQL Data In: ORACLE - Param = 119, Name = AS_YBSM09, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1197    10:16:03  SQL Data In: ORACLE - Param = 120, Name = AS_YBSM10, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1198    10:16:03  SQL Data In: ORACLE - Param = 121, Name = AS_YBSM11, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1199    10:16:03  SQL Data In: ORACLE - Param = 122, Name = AS_YBSM12, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1200    10:16:03  SQL Data In: ORACLE - Param = 123, Name = AS_YBSM13, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1201    10:16:03  SQL Data In: ORACLE - Param = 124, Name = AS_YBSM14, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1202    10:16:03  SQL Data In: ORACLE - Param = 125, Name = AS_YBSM15, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1203    10:16:03  SQL Data In: ORACLE - Param = 126, Name = AS_YBSM16, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1204    10:16:03  SQL Data In: ORACLE - Param = 127, Name = AS_YBSM17, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1205    10:16:03  SQL Data In: ORACLE - Param = 128, Name = AS_YBSM18, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1206    10:16:03  SQL Data In: ORACLE - Param = 129, Name = AS_YBSM19, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1207    10:16:03  SQL Data In: ORACLE - Param = 130, Name = AS_YBSM20, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1208    10:16:03  SQL Data In: ORACLE - Param = 131, Name = AS_YBSM21, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1209    10:16:03  SQL Data In: ORACLE - Param = 132, Name = AS_YBSM22, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1210    10:16:03  SQL Data In: ORACLE - Param = 133, Name = AS_YBSM23, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1211    10:16:03  SQL Data In: ORACLE - Param = 134, Name = AS_YBSM24, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1212    10:16:03  SQL Data In: ORACLE - Param = 135, Name = AS_YBSM25, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1213    10:16:03  SQL Data In: ORACLE - Param = 136, Name = AS_YBSM26, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1214    10:16:03  SQL Data In: ORACLE - Param = 137, Name = AS_YBSM27, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1215    10:16:03  SQL Data In: ORACLE - Param = 138, Name = AS_YBSM28, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1216    10:16:03  SQL Data In: ORACLE - Param = 139, Name = AS_YBSM29, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1217    10:16:03  SQL Data In: ORACLE - Param = 140, Name = AS_MXLSH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1218    10:16:03  SQL Data In: ORACLE - Param = 141, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1721413.000000
1219    10:16:03  SQL Data In: ORACLE - Param = 142, Name = AD_JSXZID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1220    10:16:03  SQL Data In: ORACLE - Param = 143, Name = AS_BYCS00, Type = fldZSTRING, Precision = 90, Scale = 0, Data = <JSQSRQ>20220307</JSQSRQ><JSJZRQ>20220408</JSJZRQ><MXSCBS>0</MXSCBS><YBJKTYPE>1</YBJKTYPE>
1221    10:16:03  SQL Execute: ORACLE - BEGIN "SP_ZY_YBFSJG" (AD_ZYID00 => :AD_ZYID00,AD_QSDJH0 => :AD_QSDJH0,AD_ZZDJH0 => :AD_ZZDJH0,AS_YBFSDH => :AS_YBFSDH,AD_GRZFE0 => :AD_GRZFE0,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_SBGRZH => :AD_SBGRZH,AD_SBTCJJ => :AD_SBTCJJ,AD_HJJE00 => :AD_HJJE00,AD_DBGRZF => :AD_DBGRZF,AD_GSJJZF => :AD_GSJJZF,AD_GSZFJE => :AD_GSZFJE,AD_FGSFY0 => :AD_FGSFY0,AD_BJJJZF => :AD_BJJJZF,AD_GWYBZ0 => :AD_GWYBZ0,AD_SYBXZF => :AD_SYBXZF,AD_FYBFY0 => :AD_FYBFY0,AD_YLZFJE => :AD_YLZFJE,AD_CFDXJE => :AD_CFDXJE,AD_SBZFE0 => :AD_SBZFE0,AD_BJZFE0 => :AD_BJZFE0,AD_GRZHYE => :AD_GRZHYE,AD_YPWQZF => :AD_YPWQZF,AD_YPBFZF => :AD_YPBFZF,AD_XMWQZF => :AD_XMWQZF,AD_XMBFZF => :AD_XMBFZF,AS_BJJBIE => :AS_BJJBIE,AS_YBJZRQ => :AS_YBJZRQ,AS_YBJZSJ => :AS_YBJZSJ,AS_TSBZBH => :AS_TSBZBH,AD_CFXMS0 => :AD_CFXMS0,AD_YEXM00 => :AD_YEXM00,AD_CZY000 => :AD_CZY000,AD_CZYKS0 => :AD_CZYKS0,OD_YBZFJE => :OD_YBZFJE,OD_YBZHZF => :OD_YBZHZF,OD_YBJJZF => :OD_YBJJZF,OD_YBQTZF => :OD_YBQTZF,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AD_YBYL01 => :AD_YBYL01,AD_YBYL02 => :AD_YBYL02,AD_YBYL03 => :AD_YBYL03,AD_YBYL04 => :AD_YBYL04,AD_YBYL05 => :AD_YBYL05,AD_YBYL06 => :AD_YBYL06,AD_YBYL07 => :AD_YBYL07,AD_YBYL08 => :AD_YBYL08,AD_YBYL09 => :AD_YBYL09,AD_YBYL10 => :AD_YBYL10,AD_YBYL11 => :AD_YBYL11,AD_YBYL12 => :AD_YBYL12,AD_YBYL13 => :AD_YBYL13,AD_YBYL14 => :AD_YBYL14,AD_YBYL15 => :AD_YBYL15,AD_YBYL16 => :AD_YBYL16,AD_YBYL17 => :AD_YBYL17,AD_YBYL18 => :AD_YBYL18,AD_YBYL19 => :AD_YBYL19,AD_YBYL20 => :AD_YBYL20,AD_YBYL21 => :AD_YBYL21,AD_YBYL22 => :AD_YBYL22,AD_YBYL23 => :AD_YBYL23,AD_YBYL24 => :AD_YBYL24,AD_YBYL25 => :AD_YBYL25,AD_YBYL26 => :AD_YBYL26,AD_YBYL27 => :AD_YBYL27,AD_YBYL28 => :AD_YBYL28,AD_YBYL29 => :AD_YBYL29,AD_YBYL30 => :AD_YBYL30,AD_YBYL31 => :AD_YBYL31,AD_YBYL32 => :AD_YBYL32,AD_YBYL33 => :AD_YBYL33,AD_YBYL34 => :AD_YBYL34,AD_YBYL35 => :AD_YBYL35,AD_YBYL36 => :AD_YBYL36,AD_YBYL37 => :AD_YBYL37,AD_YBYL38 => :AD_YBYL38,AD_YBYL39 => :AD_YBYL39,AD_YBYL40 => :AD_YBYL40,AD_YBYL41 => :AD_YBYL41,AD_YBYL42 => :AD_YBYL42,AD_YBYL43 => :AD_YBYL43,AD_YBYL44 => :AD_YBYL44,AD_YBYL45 => :AD_YBYL45,AD_YBYL46 => :AD_YBYL46,AD_YBYL47 => :AD_YBYL47,AD_YBYL48 => :AD_YBYL48,AD_YBYL49 => :AD_YBYL49,AD_YBYL50 => :AD_YBYL50,AD_YBYL51 => :AD_YBYL51,AD_YBYL52 => :AD_YBYL52,AD_YBYL53 => :AD_YBYL53,AD_YBYL54 => :AD_YBYL54,AD_YBYL55 => :AD_YBYL55,AD_YBYL56 => :AD_YBYL56,AD_YBYL57 => :AD_YBYL57,AD_YBYL58 => :AD_YBYL58,AD_YBYL59 => :AD_YBYL59,AD_YBYL60 => :AD_YBYL60,AD_YBYL61 => :AD_YBYL61,AD_YBYL62 => :AD_YBYL62,AD_YBYL63 => :AD_YBYL63,AD_YBYL64 => :AD_YBYL64,AD_YBYL65 => :AD_YBYL65,AD_YBYL66 => :AD_YBYL66,AD_YBYL67 => :AD_YBYL67,AD_YBYL68 => :AD_YBYL68,AD_YBYL69 => :AD_YBYL69,AS_YBSM01 => :AS_YBSM01,AS_YBSM02 => :AS_YBSM02,AS_YBSM03 => :AS_YBSM03,AS_YBSM04 => :AS_YBSM04,AS_YBSM05 => :AS_YBSM05,AS_YBSM06 => :AS_YBSM06,AS_YBSM07 => :AS_YBSM07,AS_YBSM08 => :AS_YBSM08,AS_YBSM09 => :AS_YBSM09,AS_YBSM10 => :AS_YBSM10,AS_YBSM11 => :AS_YBSM11,AS_YBSM12 => :AS_YBSM12,AS_YBSM13 => :AS_YBSM13,AS_YBSM14 => :AS_YBSM14,AS_YBSM15 => :AS_YBSM15,AS_YBSM16 => :AS_YBSM16,AS_YBSM17 => :AS_YBSM17,AS_YBSM18 => :AS_YBSM18,AS_YBSM19 => :AS_YBSM19,AS_YBSM20 => :AS_YBSM20,AS_YBSM21 => :AS_YBSM21,AS_YBSM22 => :AS_YBSM22,AS_YBSM23 => :AS_YBSM23,AS_YBSM24 => :AS_YBSM24,AS_YBSM25 => :AS_YBSM25,AS_YBSM26 => :AS_YBSM26,AS_YBSM27 => :AS_YBSM27,AS_YBSM28 => :AS_YBSM28,AS_YBSM29 => :AS_YBSM29,AS_MXLSH0 => :AS_MXLSH0,AD_ID0000 => :AD_ID0000,AD_JSXZID => :AD_JSXZID,AS_BYCS00 => :AS_BYCS00); END;
1222    10:16:03  SQL Misc: ORACLE - Set stored procedure on or off
1223    10:16:03  SQL Data In: ORACLE - Param = 1, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
1224    10:16:03  SQL Data In: ORACLE - Param = 2, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
1225    10:16:03  SQL Data In: ORACLE - Param = 3, Name = AS_JFDJHS, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
1226    10:16:03  SQL Data In: ORACLE - Param = 4, Name = AS_JMYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1227    10:16:03  SQL Data In: ORACLE - Param = 5, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
1228    10:16:03  SQL Data In: ORACLE - Param = 6, Name = AS_JSZZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220408
1229    10:16:03  SQL Data In: ORACLE - Param = 7, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1230    10:16:03  SQL Data In: ORACLE - Param = 8, Name = AD_YEXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 全部
1231    10:16:03  SQL Data In: ORACLE - Param = 9, Name = AD_DBZBM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1232    10:16:03  SQL Data In: ORACLE - Param = 10, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1233    10:16:03  SQL Data In: ORACLE - Param = 11, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1234    10:16:03  SQL Data In: ORACLE - Param = 12, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1235    10:16:03  SQL Data In: ORACLE - Param = 13, Name = AD_XJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1236    10:16:03  SQL Data In: ORACLE - Param = 14, Name = AD_ZZDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1237    10:16:03  SQL Data In: ORACLE - Param = 15, Name = AD_XJTKPJ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1238    10:16:03  SQL Data In: ORACLE - Param = 16, Name = AD_ZZTKPJ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1239    10:16:03  SQL Data In: ORACLE - Param = 17, Name = AS_XJTKXH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
1240    10:16:03  SQL Data In: ORACLE - Param = 18, Name = AS_ZZTKXH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
1241    10:16:03  SQL Data In: ORACLE - Param = 19, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
1242    10:16:03  SQL Data In: ORACLE - Param = 20, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 494.000000
1243    10:16:03  SQL Data In: ORACLE - Param = 21, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
1244    10:16:03  SQL Data In: ORACLE - Param = 22, Name = PCSLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
1245    10:16:03  SQL Data In: ORACLE - Param = 23, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1246    10:16:03  SQL Data In: ORACLE - Param = 24, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
1247    10:16:03  SQL Data In: ORACLE - Param = 25, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
1248    10:16:03  SQL Data In: ORACLE - Param = 26, Name = AS_DDLSH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
1249    10:16:03  SQL Data In: ORACLE - Param = 27, Name = AD_XJCXJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1250    10:16:03  SQL Data In: ORACLE - Param = 28, Name = AD_XJCXDJ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1251    10:16:03  SQL Data In: ORACLE - Param = 29, Name = AD_XJCXPJ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1252    10:16:03  SQL Data In: ORACLE - Param = 30, Name = AS_XJCXXH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
1253    10:16:03  SQL Data In: ORACLE - Param = 31, Name = AD_CYQKJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
1254    10:16:03  SQL Data In: ORACLE - Param = 32, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1721413.000000
1255    10:16:03  SQL Data In: ORACLE - Param = 33, Name = AD_CYZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
1256    10:16:03  SQL Data In: ORACLE - Param = 34, Name = AD_JSXZID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
1257    10:16:03  SQL Data In: ORACLE - Param = 35, Name = AD_BYCS00, Type = fldZSTRING, Precision = 108, Scale = 0, Data = <JSQSRQ>20220307</JSQSRQ><JSJZRQ>20220408</JSJZRQ><MXSCBS>0</MXSCBS><YBJKTYPE>1</YBJKTYPE><BJTDJH>0</BJTDJH>
1258    10:16:03  SQL Execute: ORACLE - BEGIN "SP_ZY_BRFY00_JS0000" (AD_ZYID00 => :AD_ZYID00,AD_JFLBID => :AD_JFLBID,AS_JFDJHS => :AS_JFDJHS,AS_JMYY00 => :AS_JMYY00,AS_CZBZ00 => :AS_CZBZ00,AS_JSZZRQ => :AS_JSZZRQ,AS_TSBZBH => :AS_TSBZBH,AD_YEXM00 => :AD_YEXM00,AD_DBZBM0 => :AD_DBZBM0,AD_JZDH00 => :AD_JZDH00,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_XJDJH0 => :AD_XJDJH0,AD_ZZDJH0 => :AD_ZZDJH0,AD_XJTKPJ => :AD_XJTKPJ,AD_ZZTKPJ => :AD_ZZTKPJ,AS_XJTKXH => :AS_XJTKXH,AS_ZZTKXH => :AS_ZZTKXH,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PCSLX00 => :PCSLX00,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,AS_DDLSH0 => :AS_DDLSH0,AD_XJCXJE => :AD_XJCXJE,AD_XJCXDJ => :AD_XJCXDJ,AD_XJCXPJ => :AD_XJCXPJ,AS_XJCXXH => :AS_XJCXXH,AD_CYQKJE => :AD_CYQKJE,AD_ID0000 => :AD_ID0000,AD_CYZT00 => :AD_CYZT00,AD_JSXZID => :AD_JSXZID,AD_BYCS00 => :AD_BYCS00); END;
1259    10:16:04  SQL Execute: ORACLE - select * from VW_ZY_JZB000 where JZDH00 = 999968.00

1260    10:16:04  SQL Misc: ORACLE - Set stored procedure on or off
1261    10:16:04  SQL Data In: ORACLE - Param = 1, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1241.000000
1262    10:16:04  SQL Data In: ORACLE - Param = 2, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 刘和琴
1263    10:16:04  SQL Data In: ORACLE - Param = 3, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4250243.000000
1264    10:16:04  SQL Data In: ORACLE - Param = 4, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
1265    10:16:04  SQL Data In: ORACLE - Param = 5, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 927436.000000
1266    10:16:04  SQL Data In: ORACLE - Param = 6, Name = AS_BRZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4
1267    10:16:04  SQL Data In: ORACLE - Param = 7, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
1268    10:16:04  SQL Data In: ORACLE - Param = 8, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
1269    10:16:04  SQL Execute: ORACLE - BEGIN "SP_ZY_YBCYDJ" (AD_JZY000 => :AD_JZY000,AS_JZYXM0 => :AS_JZYXM0,AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AD_ZYID00 => :AD_ZYID00,AS_BRZT00 => :AS_BRZT00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
1270    10:16:04  SQL Execute: ORACLE - Commit

1271    10:16:04  SQL Data In: ORACLE - Rows affected = 0
1272    10:16:04  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '床边结算参数设置' and BH0000 = 'isopen'

1273    10:16:04  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'ZYJSFYMXSFGXYBZFBL'

1274    10:16:04  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33.000000
1275    10:16:04  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = 出院结算退款 
1276    10:16:04  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
1277    10:16:04  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
1278    10:16:04  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
1279    10:16:04  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 现金
1280    10:16:04  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
1281    10:16:04  SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 支付统一平台参数
1282    10:16:04  SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
1283    10:16:04  SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
1284    10:16:04  SQL Execute: ORACLE - Select  SF_ZY_PAYLX0(?,?,?,?,?,?,?,?,?,?)FHXX00  from dual

1285    10:16:04  SQL Execute: ORACLE - select count(1) from VW_ZY_FPXX00 where JZDH00= 999968.00 

1286    10:16:04  SQL Execute: ORACLE - select SF_ZY_GETFPLX(927436.00,999968.00) as FPLX00 from dual

1287    10:16:07  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 999968
1288    10:16:07  SQL Execute: ORACLE - select * from VW_ZY_ZZFPXX where JZDH00 = ? 

1289    10:16:07  SQL Execute: ORACLE - select 1241 as UserId,'100052' as UserCode,'刘和琴' as UserName,494 as UserLogDepId,'住院收费处' as UserLogDepName, '5' as UserLogSysCode,'住院收费管理系统' as UserLogSysName,'220035' as HospitalCode,'福建省老年医院' as HospitalName, '220035' as UserLogDepYYID,'福建省老年医院' as UserLogDepYYMC  from dual 

1290    10:16:11  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = 927436.00

1291    10:16:11  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = 927436.00 

1292    10:16:11  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '腕带付床头卡接口参数' and BH0000 = 'Open_ZY'

1293    10:16:11  SQL Execute: ORACLE - select sysdate from dual

1294    10:16:11  SQL Execute: ORACLE - select 0 as XZ0000,a.* from VW_ZY_FYMX00 a where ZYID00 = -1.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' and nvl(YEXM00,'全部')='' order by MXID00

1295    10:16:11  SQL Execute: ORACLE - select * from VW_ZY_BRJFB0 where ZYID00 = -1.00 and JZDH00+0 = 0 and PLBH00 in (4,8) order by DJH000

1296    10:16:11  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0_EXT where BRID00 = -1.00 and ZYID00<> -1.00 order by ZYID00 desc 

1297    10:16:11  SQL Execute: ORACLE - select * from VW_ZY_BRXXB0 where ZYID00 = -1.00 

1298    10:16:11  SQL Execute: ORACLE - select ZYFPID,ZYFPMC,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from VW_ZY_FYMX00  where ZYID00 = -1.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' and nvl(YEXM00,'全部')='' group by ZYFPID,ZYFPMC

1299    10:16:11  SQL Execute: ORACLE - select ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH,sum(XMSL00) XMSL00,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00 from  VW_ZY_FYMX00   where ZYID00 = -1.00 and JZDH00+0 = 0 and CZRQ00 <= '20220408' and nvl(YEXM00,'全部')='' group by ZYFPID,ZYFPMC,GJBM00,XMMC00,GJBZBM,GJBZMC,XMDJ00,SFXMBH,YBXMBH

1300    10:16:11  SQL Execute: ORACLE - select * from VW_ZY_JZB000 where ZYID00 = -1.00 order by JZDH00

1301    10:16:11  SQL Execute: ORACLE - select * from VW_ZY_YZYPSQ_WQY where ZYID00 = -1.00 and SRRQ00 <= '20220408' order by SRRQ00,SRSJ00 

1302    10:16:11  SQL Execute: ORACLE - select a.* from VW_ZY_YJTFMX_WZX a where a.ZYID00 = -1.00   and a.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b where b.ZYGHID = a.ZYID00  and b.SFDJH0 in ( select c.DJH000 from ZY_FYMX00 c where c.ZYID00=a.ZYID00 and c.JZDH00+0 = 0 and c.CZRQ00<= '20220408') )  order by a.KDRQ00 desc 

1303    10:16:11  SQL Execute: ORACLE - select a.* from VW_ZY_YPTFMX_WZX a where a.ZYID00 = -1.00   and a.CXPCID in (select YPQLPC from  YF_YZYPSQ e,ZY_FYMX00 f where e.DJH000 = f.DJH000 and f.JZDH00+0 = 0     and f.ZYID00=a.ZYID00 and f.CZRQ00 <= '20220408')  order by a.SRRQ00  desc 

1304    10:16:11  SQL Execute: ORACLE - select * from VW_BQ_BRZDXX where ZYID00 = -1.00 order by ZDRQ00,ZDSJ00

1305    10:16:11  SQL Execute: ORACLE - select nvl(sum(NVL(HJJE00,0)),0) HJJE00, nvl(sum(NVL(ZFJE00,0)),0) ZFJE00, nvl(sum(NVL(JZJE00,0)),0) JZJE00, nvl(sum(NVL(GFJE00,0)),0) GFJE00, nvl(sum(nvl(JMJE00,0)),0) JMJE00, nvl(min(DJH000),0) QSDJH0,nvl(max(DJH000),0) ZZDJH0,   nvl(max(YEXM00),'全部') YEXM00, nvl(min(QDRQ00),'19000101') JSQSRQ, nvl(max(QDRQ00),'20220408') JSJZRQ from VW_ZY_FYMX00 where JZDH00+0 = 0 and JFLBID = 2 and ZYID00 = -1.00 and CZRQ00<= '20220408' and YEXM00 = '' 

1306    10:16:11  SQL Execute: ORACLE - select * from VW_ZY_BRZHXX where ZYID00 = -1.00 

1307    10:16:11  SQL Execute: ORACLE - select SF_ZY_GETPJXH(1241,8,494) as PJDQH0 from dual

1308    10:16:11  SQL Execute: ORACLE - select sysdate from dual