1       11:17:27  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 345945
2       11:17:27  SQL Execute: ORACLE - SELECT '0' CHECK0,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00
  AS DJL000,PCMC00,
 rtrim(YFSMMC)||' '||rtrim(YPYFMC)||' '||rtrim(ZJYFMC)||' '||rtrim(XMYFMC) as YYFF00,
 YYSJ00*ZQCD00||YYSJDW AS YYTS00,YBLB00,ZFBL00,ZB0000,YPNM00
FROM YF_ZYCFMX
WHERE  CFLSH0=? 
ORDER BY ZB0000

3       11:17:27  SQL Execute: ORACLE - SELECT INSTR('345945*','*',1,1) LENGHT FROM DUAL

4       11:17:27  SQL Execute: ORACLE - SELECT CFZT00,SFKSLY FROM YF_ZYCF00 WHERE CFLSH0='345945'

5       11:17:27  SQL Execute: ORACLE - SELECT INSTR('345945*','*',1,2) LENGHT FROM DUAL

6       11:17:27  SQL Execute: ORACLE - SELECT INSTR('345945*','*',1,1) LENGHT FROM DUAL

7       11:17:27  SQL Execute: ORACLE - SELECT CFZT00,SFKSLY,DQKS00,DQBQ00,CFSRBZ,ZYDJS0,YPDLBH
 FROM YF_ZYCF00 WHERE CFLSH0='345945'

8       11:17:27  SQL Execute: ORACLE -  select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='2' and MKDM00='2E3' and ( 
 (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 
 where XTDM00='2' and ZBDM00 in ( select ZBDM00 from 
 VW_XT_YHZB00 where YGBH00=1198))))

9       11:17:27  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1099024
10      11:17:27  SQL Execute: ORACLE - select count(*)   V_COUNT0 from  BM_BRXTB0 
 where to_char(sysdate,'YYYYMMDD')>=QYRQ00 and to_char(sysdate,'YYYYMMDDHH24:MI:SS')>=QYRQ00||QYSJ00
 and TZRQ00>=to_char(sysdate,'YYYYMMDD') and TZRQ00||TZSJ00>=to_char(sysdate,'YYYYMMDDHH24:MI:SS') and BRID00=?

11      11:17:27  SQL Data In: ORACLE - Param = 1, Name = P_CFLSH0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 345945
12      11:17:27  SQL Data In: ORACLE - Param = 2, Name = P_CFJSZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
13      11:17:27  SQL Data In: ORACLE - Param = 3, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 480.000000
14      11:17:27  SQL Data In: ORACLE - Param = 4, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1198.000000
15      11:17:27  SQL Data In: ORACLE - Param = 5, Name = P_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
16      11:17:27  SQL Data In: ORACLE - Param = 6, Name = P_SFHY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
17      11:17:27  SQL Execute: ORACLE - BEGIN "SP_YF_ZYCFCL" (P_CFLSH0 => :P_CFLSH0,P_CFJSZT => :P_CFJSZT,P_YFBMBH => :P_YFBMBH,P_CZYBH0 => :P_CZYBH0,P_DJH000 => :P_DJH000,P_SFHY00 => :P_SFHY00); END;
18      11:17:27  SQL Error: ORACLE - ORA-20266: ORA-20266: ORA-20903: 账户金额不够，操作失败！*可用余额-128.35,允许欠费0,项目金额49.16;
ORA-06512: 在 "SD_HOSPITAL.TR_ZY
ORA-06512: 在 "SD_HOSPITAL.SP_YF_ZYCFCL", line 370
ORA-06512: 在 line 1

19      11:17:27  SQL Error: ORACLE - Unmapped SQL Error Code: 20266
20      11:17:27  SQL Execute: ORACLE - ROLLBACK WORK
21      11:17:34  SQL Execute: ORACLE - SELECT INSTR('345945*','*',1,2) LENGHT FROM DUAL

22      11:17:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
23      11:17:35  SQL Execute: ORACLE - select a.BRID00,nvl(a.BRXM00,'无') BRXM00,nvl(a.BRLXDH,'无') BRLXDH from BM_BRXXB0 a where a.BRID00=? and rownum=1 

24      11:17:35  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
25      11:17:35  SQL Execute: ORACLE - select a.BRID00,nvl(a.XM0000,'无') BRXM00  from ZY_BRXXB0 a where a.BRID00=? and rownum=1 ;

26      11:17:35  SQL Error: ORACLE - ORA-00911: 无效字符

27      11:17:35  SQL Error: ORACLE - Unmapped SQL Error Code: 911
28      11:17:35  SQL Data In: ORACLE - Rows affected = 0