1       10:42:32  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
2       10:42:32  SQL Execute: ORACLE - select *  from VW_SF_YJYWMX
where YJDJH0=?

3       10:42:32  SQL Execute: ORACLE - select * from  VW_ZY_YJYW00 A where  A.brid00 = -1
 and  A.CXDJH0 in ( select YJDJH0  from  YJ_YW0000 where ZYGHID = A.ZYID00  and  SFDJH0 in ( select DJH000 from ZY_BRFY00  where ZYID00=A.ZYID00 and JZDH00+0 = 0 )) 
 and  A.SFDJH0 = 0 and A.YJKSBH=123
 order by  A.KDRQ00  desc  

4       10:42:32  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
5       10:42:32  SQL Execute: ORACLE - select *  from VW_SF_YJYWMX
where YJDJH0=?

6       10:42:34  SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
7       10:42:34  SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 1
8       10:42:34  SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 1706462
9       10:42:34  SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
10      10:42:34  SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
11      10:42:34  SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
12      10:42:34  SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
13      10:42:34  SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
14      10:42:34  SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
15      10:42:34  SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
16      10:42:34  SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
17      10:42:34  SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
18      10:42:34  SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
19      10:42:34  SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
20      10:42:34  SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
21      10:42:34  SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
22      10:42:34  SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
23      10:42:34  SQL Data In: ORACLE - Param = 18, Name = PBRZTQK, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
24      10:42:34  SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00,PBRZTQK => :PBRZTQK); END;
25      10:42:34  SQL Error: ORACLE - ORA-06550: 第 1 行, 第 7 列: 
PLS-00306: 调用 'SP_YJ_GETBRXX' 时参数个数或类型错误
ORA-06550: 第 1 行, 第 7 列: 
PL/SQL: Statement ignored

26      10:42:34  SQL Error: ORACLE - Unmapped SQL Error Code: 6550
27      10:42:39  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = 'O')) or XXXZ00='0')
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',123,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1150
  AND b.JSKSBH = '123')
  AND (INSTR (',' || a.jsksbh || ',',',123,') > 0 or a.jsksbh is null)