1 15:15:47 SQL Data In: ORACLE - Param = 1, Name = AD_ZLXMID, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 23713 2 15:15:47 SQL Data In: ORACLE - Param = 2, Name = AS_ZLXMBH, Type = fldZSTRING, Precision = 10, Scale = 0, Data = Z001001027 3 15:15:47 SQL Data In: ORACLE - Param = 3, Name = AS_ZLXMJC, Type = fldZSTRING, Precision = 39, Scale = 0, Data = 急诊监护费[符合监护病房条件和管理标准， 4 15:15:47 SQL Data In: ORACLE - Param = 4, Name = AS_LBBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 5 15:15:47 SQL Data In: ORACLE - Param = 5, Name = AS_FBZXBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 6 15:15:47 SQL Data In: ORACLE - Param = 6, Name = AS_GDXMBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 7 15:15:47 SQL Data In: ORACLE - Param = 7, Name = AS_JGDW00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 8 15:15:47 SQL Data In: ORACLE - Param = 8, Name = AS_CKZ000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 9 15:15:47 SQL Data In: ORACLE - Param = 9, Name = AS_DW0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 日 10 15:15:47 SQL Data In: ORACLE - Param = 10, Name = AS_WBSM00, Type = fldZSTRING, Precision = 15, Scale = 0, Data = qyjrxtwjruytwtt 11 15:15:47 SQL Data In: ORACLE - Param = 11, Name = AS_PYSM00, Type = fldZSTRING, Precision = 15, Scale = 0, Data = jzjhffhjhbftjhg 12 15:15:47 SQL Data In: ORACLE - Param = 12, Name = AS_XXMS00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 13 15:15:47 SQL Data In: ORACLE - Param = 13, Name = AS_BZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 14 15:15:47 SQL Data In: ORACLE - Param = 14, Name = AS_SFYXSQ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 15 15:15:47 SQL Data In: ORACLE - Param = 15, Name = AD_ZXKS00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 553 16 15:15:47 SQL Data In: ORACLE - Param = 16, Name = AS_DLBQZX, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 17 15:15:47 SQL Data In: ORACLE - Param = 17, Name = AS_DLKSZX, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 18 15:15:47 SQL Data In: ORACLE - Param = 18, Name = AS_BQDYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 19 15:15:47 SQL Data In: ORACLE - Param = 19, Name = AS_BBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 20 15:15:47 SQL Data In: ORACLE - Param = 20, Name = AS_ZYZBID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 21 15:15:47 SQL Data In: ORACLE - Param = 21, Name = AS_JYTZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 22 15:15:47 SQL Data In: ORACLE - Param = 22, Name = AS_JKBH01, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 23 15:15:47 SQL Data In: ORACLE - Param = 23, Name = AS_ZHXMBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 24 15:15:47 SQL Data In: ORACLE - Param = 24, Name = AD_JCLBID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 25 15:15:47 SQL Data In: ORACLE - Param = 25, Name = ad_SQDID0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 26 15:15:47 SQL Data In: ORACLE - Param = 26, Name = as_QYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120711 27 15:15:47 SQL Data In: ORACLE - Param = 27, Name = as_TZRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 28 15:15:47 SQL Data In: ORACLE - Param = 28, Name = AS_FYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 29 15:15:47 SQL Data In: ORACLE - Param = 29, Name = ad_JCZID0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 30 15:15:47 SQL Data In: ORACLE - Param = 30, Name = as_ZYMZBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 31 15:15:47 SQL Data In: ORACLE - Param = 31, Name = ad_DAXXID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 32 15:15:47 SQL Data In: ORACLE - Param = 32, Name = ad_ZYSQID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 33 15:15:47 SQL Data In: ORACLE - Param = 33, Name = ad_SFCSSX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 34 15:15:47 SQL Data In: ORACLE - Param = 34, Name = ad_SSDJBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 35 15:15:47 SQL Data In: ORACLE - Param = 35, Name = as_FLAG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 36 15:15:47 SQL Data In: ORACLE - Param = 36, Name = as_USEMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 37 15:15:47 SQL Data In: ORACLE - Param = 37, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 38 15:15:47 SQL Data In: ORACLE - Param = 38, Name = ad_JCMLID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 39 15:15:47 SQL Data In: ORACLE - Param = 39, Name = as_CYGLX0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 40 15:15:47 SQL Data In: ORACLE - Param = 40, Name = as_BWBH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 41 15:15:47 SQL Data In: ORACLE - Param = 41, Name = as_XBXZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 42 15:15:47 SQL Data In: ORACLE - Param = 42, Name = as_SFXZJZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 43 15:15:47 SQL Execute: ORACLE - BEGIN "SP_BM_ZLXMXG" (AD_ZLXMID => :AD_ZLXMID,AS_ZLXMBH => :AS_ZLXMBH,AS_ZLXMJC => :AS_ZLXMJC,AS_LBBZ00 => :AS_LBBZ00,AS_FBZXBZ => :AS_FBZXBZ,AS_GDXMBZ => :AS_GDXMBZ,AS_JGDW00 => :AS_JGDW00,AS_CKZ000 => :AS_CKZ000,AS_DW0000 => :AS_DW0000,AS_WBSM00 => :AS_WBSM00,AS_PYSM00 => :AS_PYSM00,AS_XXMS00 => :AS_XXMS00,AS_BZ0000 => :AS_BZ0000,AS_SFYXSQ => :AS_SFYXSQ,AD_ZXKS00 => :AD_ZXKS00,AS_DLBQZX => :AS_DLBQZX,AS_DLKSZX => :AS_DLKSZX,AS_BQDYBZ => :AS_BQDYBZ,AS_BBID00 => :AS_BBID00,AS_ZYZBID => :AS_ZYZBID,AS_JYTZBH => :AS_JYTZBH,AS_JKBH01 => :AS_JKBH01,AS_ZHXMBZ => :AS_ZHXMBZ,AD_JCLBID => :AD_JCLBID,ad_SQDID0 => :ad_SQDID0,as_QYRQ00 => :as_QYRQ00,as_TZRQ00 => :as_TZRQ00,AS_FYID00 => :AS_FYID00,ad_JCZID0 => :ad_JCZID0,as_ZYMZBZ => :as_ZYMZBZ,ad_DAXXID => :ad_DAXXID,ad_ZYSQID => :ad_ZYSQID,ad_SFCSSX => :ad_SFCSSX,ad_SSDJBH => :ad_SSDJBH,as_FLAG00 => :as_FLAG00,as_USEMSG => :as_USEMSG,as_SYSMSG => :as_SYSMSG,ad_JCMLID => :ad_JCMLID,as_CYGLX0 => :as_CYGLX0,as_BWBH00 => :as_BWBH00,as_XBXZ00 => :as_XBXZ00,as_SFXZJZ => :as_SFXZJZ); END; 44 15:15:47 SQL Error: ORACLE - ORA-06550: 第 1 行, 第 7 列: PLS-00306: 调用 'SP_BM_ZLXMXG' 时参数个数或类型错误 ORA-06550: 第 1 行, 第 7 列: PL/SQL: Statement ignored 45 15:15:47 SQL Error: ORACLE - Unmapped SQL Error Code: 6550 46 15:15:47 SQL Execute: ORACLE - rollback 47 15:15:47 SQL Data In: ORACLE - Rows affected = 0 48 15:15:52 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '7') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',474,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '474') AND (INSTR (',' || a.jsksbh || ',',',474,') > 0 or a.jsksbh is null) 49 15:16:02 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '7') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',474,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '474') AND (INSTR (',' || a.jsksbh || ',',',474,') > 0 or a.jsksbh is null)