1546 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1547 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc041 1548 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1549 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 1550 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1551 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc045 1552 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1553 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 1554 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1555 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc059 1556 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1557 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 1558 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1559 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc052 1560 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1561 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 1562 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1563 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc062 1564 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1565 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 1566 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1567 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc060 1568 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1569 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 1570 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1571 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ake173 1572 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1573 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 1574 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1575 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ake026 1576 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1577 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 1578 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1579 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc011 1580 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1581 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 1582 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1583 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = akc087 1584 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1585 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 1586 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1587 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aka151 1588 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1589 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 1590 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1591 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aka150 1592 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1593 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 1594 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1595 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc612 1596 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1597 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 1598 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1599 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc064 1600 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1601 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 1602 17:40:07 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBSM01' and YBYLZD<='YBSM50' and YBZDBM is not null order by YBYLZD 1603 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1604 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aaz149 1605 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1606 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual 1607 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1608 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = jsbllx 1609 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1610 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual 1611 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1612 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bka188 1613 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1614 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual 1615 17:40:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1616 17:40:07 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bka555 1617 17:40:07 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1618 17:40:07 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual 1619 17:40:07 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8110614.000000 1620 17:40:07 SQL Data In: ORACLE - Param = 2, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933588.000000 1621 17:40:07 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1622 17:40:07 SQL Data In: ORACLE - Param = 4, Name = PCFMXS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1623 17:40:07 SQL Data In: ORACLE - Param = 5, Name = PYBZHYE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 122.760000 1624 17:40:07 SQL Data In: ORACLE - Param = 6, Name = PYBDJH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1520193 1625 17:40:07 SQL Data In: ORACLE - Param = 7, Name = PBCBXF0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 170.890000 1626 17:40:07 SQL Data In: ORACLE - Param = 8, Name = PJJZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 128.270000 1627 17:40:07 SQL Data In: ORACLE - Param = 9, Name = PZHZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 42.620000 1628 17:40:07 SQL Data In: ORACLE - Param = 10, Name = PDBZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1629 17:40:07 SQL Data In: ORACLE - Param = 11, Name = PDBJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1630 17:40:07 SQL Data In: ORACLE - Param = 12, Name = PSYBXZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1631 17:40:07 SQL Data In: ORACLE - Param = 13, Name = PBJJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1632 17:40:07 SQL Data In: ORACLE - Param = 14, Name = PSBZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1633 17:40:07 SQL Data In: ORACLE - Param = 15, Name = PBJZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1634 17:40:07 SQL Data In: ORACLE - Param = 16, Name = PGWYBZ0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1635 17:40:07 SQL Data In: ORACLE - Param = 17, Name = PDBGRZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1636 17:40:07 SQL Data In: ORACLE - Param = 18, Name = PGRZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1637 17:40:07 SQL Data In: ORACLE - Param = 19, Name = PBCKBCS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1638 17:40:07 SQL Data In: ORACLE - Param = 20, Name = PFYBFY0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1639 17:40:07 SQL Data In: ORACLE - Param = 21, Name = PYLZFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1640 17:40:07 SQL Data In: ORACLE - Param = 22, Name = PCFDXJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1641 17:40:07 SQL Data In: ORACLE - Param = 23, Name = PTSBZBH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = M01600 1642 17:40:07 SQL Data In: ORACLE - Param = 24, Name = PYBSFRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 1643 17:40:07 SQL Data In: ORACLE - Param = 25, Name = PYBSFSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 1644 17:40:07 SQL Data In: ORACLE - Param = 26, Name = PCXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 1645 17:40:07 SQL Data In: ORACLE - Param = 27, Name = PCXJZDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1646 17:40:07 SQL Data In: ORACLE - Param = 28, Name = PTMLJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1647 17:40:07 SQL Data In: ORACLE - Param = 29, Name = PYBGHH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4985839 1648 17:40:07 SQL Data In: ORACLE - Param = 30, Name = PZYYBJK, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 1649 17:40:07 SQL Data In: ORACLE - Param = 31, Name = PBXLB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1650 17:40:07 SQL Data In: ORACLE - Param = 32, Name = PMXZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1651 17:40:07 SQL Data In: ORACLE - Param = 33, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 1652 17:40:07 SQL Data In: ORACLE - Param = 34, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 1653 17:40:07 SQL Data In: ORACLE - Param = 35, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 1654 17:40:07 SQL Data In: ORACLE - Param = 36, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1655 17:40:07 SQL Data In: ORACLE - Param = 37, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1656 17:40:07 SQL Data In: ORACLE - Param = 38, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1657 17:40:07 SQL Data In: ORACLE - Param = 39, Name = PYBYL01, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1658 17:40:07 SQL Data In: ORACLE - Param = 40, Name = PYBYL02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1659 17:40:07 SQL Data In: ORACLE - Param = 41, Name = PYBYL03, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1660 17:40:07 SQL Data In: ORACLE - Param = 42, Name = PYBYL04, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1661 17:40:07 SQL Data In: ORACLE - Param = 43, Name = PYBYL05, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1662 17:40:07 SQL Data In: ORACLE - Param = 44, Name = PYBYL06, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1663 17:40:07 SQL Data In: ORACLE - Param = 45, Name = PYBYL07, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1664 17:40:07 SQL Data In: ORACLE - Param = 46, Name = PYBYL08, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1665 17:40:07 SQL Data In: ORACLE - Param = 47, Name = PYBYL09, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1666 17:40:07 SQL Data In: ORACLE - Param = 48, Name = PYBYL10, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1667 17:40:07 SQL Data In: ORACLE - Param = 49, Name = PYBYL11, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1668 17:40:07 SQL Data In: ORACLE - Param = 50, Name = PYBYL12, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1669 17:40:07 SQL Data In: ORACLE - Param = 51, Name = PYBYL13, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1670 17:40:07 SQL Data In: ORACLE - Param = 52, Name = PYBYL14, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1671 17:40:07 SQL Data In: ORACLE - Param = 53, Name = PYBYL15, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1672 17:40:07 SQL Data In: ORACLE - Param = 54, Name = PYBYL16, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1673 17:40:07 SQL Data In: ORACLE - Param = 55, Name = PYBYL17, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1674 17:40:07 SQL Data In: ORACLE - Param = 56, Name = PYBYL18, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1675 17:40:07 SQL Data In: ORACLE - Param = 57, Name = PYBYL19, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1676 17:40:07 SQL Data In: ORACLE - Param = 58, Name = PYBYL20, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1677 17:40:07 SQL Data In: ORACLE - Param = 59, Name = PYBYL21, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1678 17:40:07 SQL Data In: ORACLE - Param = 60, Name = PYBYL22, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1679 17:40:07 SQL Data In: ORACLE - Param = 61, Name = PYBYL23, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1680 17:40:07 SQL Data In: ORACLE - Param = 62, Name = PYBYL24, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1681 17:40:07 SQL Data In: ORACLE - Param = 63, Name = PYBYL25, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1682 17:40:07 SQL Data In: ORACLE - Param = 64, Name = PYBYL26, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1683 17:40:07 SQL Data In: ORACLE - Param = 65, Name = PYBYL27, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1684 17:40:07 SQL Data In: ORACLE - Param = 66, Name = PYBYL28, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1685 17:40:07 SQL Data In: ORACLE - Param = 67, Name = PYBYL29, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1686 17:40:07 SQL Data In: ORACLE - Param = 68, Name = PYBYL30, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1687 17:40:07 SQL Data In: ORACLE - Param = 69, Name = PYBYL31, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1688 17:40:07 SQL Data In: ORACLE - Param = 70, Name = PYBYL32, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1689 17:40:07 SQL Data In: ORACLE - Param = 71, Name = PYBYL33, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1690 17:40:07 SQL Data In: ORACLE - Param = 72, Name = PYBYL34, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1691 17:40:07 SQL Data In: ORACLE - Param = 73, Name = PYBYL35, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1692 17:40:07 SQL Data In: ORACLE - Param = 74, Name = PYBYL36, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1693 17:40:07 SQL Data In: ORACLE - Param = 75, Name = PYBYL37, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1694 17:40:07 SQL Data In: ORACLE - Param = 76, Name = PYBYL38, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1695 17:40:07 SQL Data In: ORACLE - Param = 77, Name = PYBYL39, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1696 17:40:07 SQL Data In: ORACLE - Param = 78, Name = PYBYL40, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1697 17:40:07 SQL Data In: ORACLE - Param = 79, Name = PYBYL41, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1698 17:40:07 SQL Data In: ORACLE - Param = 80, Name = PYBYL42, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1699 17:40:07 SQL Data In: ORACLE - Param = 81, Name = PYBYL43, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1700 17:40:07 SQL Data In: ORACLE - Param = 82, Name = PYBYL44, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1701 17:40:07 SQL Data In: ORACLE - Param = 83, Name = PYBYL45, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1702 17:40:07 SQL Data In: ORACLE - Param = 84, Name = PYBYL46, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1703 17:40:07 SQL Data In: ORACLE - Param = 85, Name = PYBYL47, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1704 17:40:07 SQL Data In: ORACLE - Param = 86, Name = PYBYL48, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1705 17:40:07 SQL Data In: ORACLE - Param = 87, Name = PYBYL49, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1706 17:40:07 SQL Data In: ORACLE - Param = 88, Name = PYBYL50, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1707 17:40:07 SQL Data In: ORACLE - Param = 89, Name = PYBYL51, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1708 17:40:07 SQL Data In: ORACLE - Param = 90, Name = PYBYL52, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 170.890000 1709 17:40:07 SQL Data In: ORACLE - Param = 91, Name = PYBYL53, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 128.270000 1710 17:40:07 SQL Data In: ORACLE - Param = 92, Name = PYBYL54, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1711 17:40:07 SQL Data In: ORACLE - Param = 93, Name = PYBYL55, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 42.620000 1712 17:40:07 SQL Data In: ORACLE - Param = 94, Name = PYBYL56, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 128.270000 1713 17:40:07 SQL Data In: ORACLE - Param = 95, Name = PYBYL57, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1714 17:40:07 SQL Data In: ORACLE - Param = 96, Name = PYBYL58, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1715 17:40:07 SQL Data In: ORACLE - Param = 97, Name = PYBYL59, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1716 17:40:07 SQL Data In: ORACLE - Param = 98, Name = PYBYL60, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1717 17:40:07 SQL Data In: ORACLE - Param = 99, Name = PYBYL61, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1718 17:40:07 SQL Data In: ORACLE - Param = 100, Name = PYBYL62, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1719 17:40:07 SQL Data In: ORACLE - Param = 101, Name = PYBYL63, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1720 17:40:07 SQL Data In: ORACLE - Param = 102, Name = PYBYL64, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 122.760000 1721 17:40:07 SQL Data In: ORACLE - Param = 103, Name = PYBYL65, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1722 17:40:08 SQL Data In: ORACLE - Param = 104, Name = PYBYL66, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1723 17:40:08 SQL Data In: ORACLE - Param = 105, Name = PYBYL67, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1724 17:40:08 SQL Data In: ORACLE - Param = 106, Name = PYBYL68, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1725 17:40:08 SQL Data In: ORACLE - Param = 107, Name = PYBYL69, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1726 17:40:08 SQL Data In: ORACLE - Param = 108, Name = PYBSM01, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1727 17:40:08 SQL Data In: ORACLE - Param = 109, Name = PYBSM02, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1728 17:40:08 SQL Data In: ORACLE - Param = 110, Name = PYBSM03, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1729 17:40:08 SQL Data In: ORACLE - Param = 111, Name = PYBSM04, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1730 17:40:08 SQL Data In: ORACLE - Param = 112, Name = PYBSM05, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1731 17:40:08 SQL Data In: ORACLE - Param = 113, Name = PYBSM06, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1732 17:40:08 SQL Data In: ORACLE - Param = 114, Name = PYBSM07, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1733 17:40:08 SQL Data In: ORACLE - Param = 115, Name = PYBSM08, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1734 17:40:08 SQL Data In: ORACLE - Param = 116, Name = PYBSM09, Type = fldZSTRING, Precision = 6, Scale = 0, Data = M01600 1735 17:40:08 SQL Data In: ORACLE - Param = 117, Name = PYBSM10, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1736 17:40:08 SQL Data In: ORACLE - Param = 118, Name = PYBSM11, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1737 17:40:08 SQL Data In: ORACLE - Param = 119, Name = PYBSM12, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1738 17:40:08 SQL Data In: ORACLE - Param = 120, Name = PYBSM13, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1739 17:40:08 SQL Data In: ORACLE - Param = 121, Name = PYBSM14, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1740 17:40:08 SQL Data In: ORACLE - Param = 122, Name = PYBSM15, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1741 17:40:08 SQL Data In: ORACLE - Param = 123, Name = PYBSM16, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1742 17:40:08 SQL Data In: ORACLE - Param = 124, Name = PYBSM17, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1743 17:40:08 SQL Data In: ORACLE - Param = 125, Name = PYBSM18, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1744 17:40:08 SQL Data In: ORACLE - Param = 126, Name = PYBSM19, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1745 17:40:08 SQL Data In: ORACLE - Param = 127, Name = PYBSM20, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1746 17:40:08 SQL Data In: ORACLE - Param = 128, Name = PYBSM21, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1747 17:40:08 SQL Data In: ORACLE - Param = 129, Name = PYBSM22, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1748 17:40:08 SQL Data In: ORACLE - Param = 130, Name = PYBSM23, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1749 17:40:08 SQL Data In: ORACLE - Param = 131, Name = PYBSM24, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1750 17:40:08 SQL Data In: ORACLE - Param = 132, Name = PYBSM25, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1751 17:40:08 SQL Data In: ORACLE - Param = 133, Name = PYBSM26, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1752 17:40:08 SQL Data In: ORACLE - Param = 134, Name = PYBSM27, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1753 17:40:08 SQL Data In: ORACLE - Param = 135, Name = PYBSM28, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1754 17:40:08 SQL Data In: ORACLE - Param = 136, Name = PYBSM29, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1755 17:40:08 SQL Data In: ORACLE - Param = 137, Name = Psfyjs0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1756 17:40:08 SQL Data In: ORACLE - Param = 138, Name = Pybjkid, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419755 1757 17:40:08 SQL Data In: ORACLE - Param = 139, Name = Pmxlsh0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 16337724034011542483 1758 17:40:08 SQL Data In: ORACLE - Param = 140, Name = Pghid00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8516590 1759 17:40:08 SQL Data In: ORACLE - Param = 141, Name = Pghh000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1760 17:40:08 SQL Execute: ORACLE - BEGIN "SP_SF_YBFYJS_REPLY" (PID0000 => :PID0000,PJZDH00 => :PJZDH00,PBRID00 => :PBRID00,PCFMXS0 => :PCFMXS0,PYBZHYE => :PYBZHYE,PYBDJH0 => :PYBDJH0,PBCBXF0 => :PBCBXF0,PJJZFE0 => :PJJZFE0,PZHZFE0 => :PZHZFE0,PDBZHZF => :PDBZHZF,PDBJJZF => :PDBJJZF,PSYBXZF => :PSYBXZF,PBJJJZF => :PBJJJZF,PSBZFE0 => :PSBZFE0,PBJZFE0 => :PBJZFE0,PGWYBZ0 => :PGWYBZ0,PDBGRZF => :PDBGRZF,PGRZFE0 => :PGRZFE0,PBCKBCS => :PBCKBCS,PFYBFY0 => :PFYBFY0,PYLZFJE => :PYLZFJE,PCFDXJE => :PCFDXJE,PTSBZBH => :PTSBZBH,PYBSFRQ => :PYBSFRQ,PYBSFSJ => :PYBSFSJ,PCXBZ00 => :PCXBZ00,PCXJZDH => :PCXJZDH,PTMLJ00 => :PTMLJ00,PYBGHH0 => :PYBGHH0,PZYYBJK => :PZYYBJK,PBXLB00 => :PBXLB00,PMXZJE0 => :PMXZJE0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PYBYL01 => :PYBYL01,PYBYL02 => :PYBYL02,PYBYL03 => :PYBYL03,PYBYL04 => :PYBYL04,PYBYL05 => :PYBYL05,PYBYL06 => :PYBYL06,PYBYL07 => :PYBYL07,PYBYL08 => :PYBYL08,PYBYL09 => :PYBYL09,PYBYL10 => :PYBYL10,PYBYL11 => :PYBYL11,PYBYL12 => :PYBYL12,PYBYL13 => :PYBYL13,PYBYL14 => :PYBYL14,PYBYL15 => :PYBYL15,PYBYL16 => :PYBYL16,PYBYL17 => :PYBYL17,PYBYL18 => :PYBYL18,PYBYL19 => :PYBYL19,PYBYL20 => :PYBYL20,PYBYL21 => :PYBYL21,PYBYL22 => :PYBYL22,PYBYL23 => :PYBYL23,PYBYL24 => :PYBYL24,PYBYL25 => :PYBYL25,PYBYL26 => :PYBYL26,PYBYL27 => :PYBYL27,PYBYL28 => :PYBYL28,PYBYL29 => :PYBYL29,PYBYL30 => :PYBYL30,PYBYL31 => :PYBYL31,PYBYL32 => :PYBYL32,PYBYL33 => :PYBYL33,PYBYL34 => :PYBYL34,PYBYL35 => :PYBYL35,PYBYL36 => :PYBYL36,PYBYL37 => :PYBYL37,PYBYL38 => :PYBYL38,PYBYL39 => :PYBYL39,PYBYL40 => :PYBYL40,PYBYL41 => :PYBYL41,PYBYL42 => :PYBYL42,PYBYL43 => :PYBYL43,PYBYL44 => :PYBYL44,PYBYL45 => :PYBYL45,PYBYL46 => :PYBYL46,PYBYL47 => :PYBYL47,PYBYL48 => :PYBYL48,PYBYL49 => :PYBYL49,PYBYL50 => :PYBYL50,PYBYL51 => :PYBYL51,PYBYL52 => :PYBYL52,PYBYL53 => :PYBYL53,PYBYL54 => :PYBYL54,PYBYL55 => :PYBYL55,PYBYL56 => :PYBYL56,PYBYL57 => :PYBYL57,PYBYL58 => :PYBYL58,PYBYL59 => :PYBYL59,PYBYL60 => :PYBYL60,PYBYL61 => :PYBYL61,PYBYL62 => :PYBYL62,PYBYL63 => :PYBYL63,PYBYL64 => :PYBYL64,PYBYL65 => :PYBYL65,PYBYL66 => :PYBYL66,PYBYL67 => :PYBYL67,PYBYL68 => :PYBYL68,PYBYL69 => :PYBYL69,PYBSM01 => :PYBSM01,PYBSM02 => :PYBSM02,PYBSM03 => :PYBSM03,PYBSM04 => :PYBSM04,PYBSM05 => :PYBSM05,PYBSM06 => :PYBSM06,PYBSM07 => :PYBSM07,PYBSM08 => :PYBSM08,PYBSM09 => :PYBSM09,PYBSM10 => :PYBSM10,PYBSM11 => :PYBSM11,PYBSM12 => :PYBSM12,PYBSM13 => :PYBSM13,PYBSM14 => :PYBSM14,PYBSM15 => :PYBSM15,PYBSM16 => :PYBSM16,PYBSM17 => :PYBSM17,PYBSM18 => :PYBSM18,PYBSM19 => :PYBSM19,PYBSM20 => :PYBSM20,PYBSM21 => :PYBSM21,PYBSM22 => :PYBSM22,PYBSM23 => :PYBSM23,PYBSM24 => :PYBSM24,PYBSM25 => :PYBSM25,PYBSM26 => :PYBSM26,PYBSM27 => :PYBSM27,PYBSM28 => :PYBSM28,PYBSM29 => :PYBSM29,Psfyjs0 => :Psfyjs0,Pybjkid => :Pybjkid,Pmxlsh0 => :Pmxlsh0,Pghid00 => :Pghid00,Pghh000 => :Pghh000); END; 1761 17:40:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933588.000000 1762 17:40:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933588.000000 1763 17:40:08 SQL Execute: ORACLE - select sum(jmje00) jmje00 from ( select nvl(sum(-a.hjje00),0) jmje00 from SF_FYMX00_TEMP00 a where a.jzdh00 = ? and a.xmbh00 >9999999900 and a.xmbh00<9999999990 union all select nvl(sum(a.jmje00),0) jmje00 from SF_FYMX00_TEMP00 a where a.jzdh00 = ? and a.jmbz00 in ('3','4')) 1764 17:40:08 SQL Data In: ORACLE - Param = 1, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933588.000000 1765 17:40:08 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1766 17:40:08 SQL Data In: ORACLE - Param = 3, Name = PPJH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1767 17:40:08 SQL Data In: ORACLE - Param = 4, Name = PCZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 1768 17:40:08 SQL Data In: ORACLE - Param = 5, Name = PCZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:39:55 1769 17:40:08 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 1770 17:40:08 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 1771 17:40:08 SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 1772 17:40:08 SQL Data In: ORACLE - Param = 9, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1773 17:40:08 SQL Data In: ORACLE - Param = 10, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1774 17:40:08 SQL Data In: ORACLE - Param = 11, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1775 17:40:08 SQL Execute: ORACLE - BEGIN "SP_SF_YBFYJS_INSERT" (PJZDH00 => :PJZDH00,PBRID00 => :PBRID00,PPJH000 => :PPJH000,PCZRQ00 => :PCZRQ00,PCZSJ00 => :PCZSJ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 1776 17:40:08 SQL Execute: ORACLE - Select SQ_YF_MZCF00_KFPC00.NextVal Val from Dual 1777 17:40:08 SQL Execute: ORACLE - Select SQ_SF_BRJFB0_DJH000.NextVal Val from Dual 1778 17:40:08 SQL Data In: ORACLE - Param = 1, Name = AS_CFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6194541 1779 17:40:08 SQL Data In: ORACLE - Param = 2, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 25390140.000000 1780 17:40:08 SQL Data In: ORACLE - Param = 3, Name = AD_SFCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1781 17:40:08 SQL Data In: ORACLE - Param = 4, Name = AD_PYCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1782 17:40:08 SQL Data In: ORACLE - Param = 5, Name = AD_FYCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1783 17:40:08 SQL Data In: ORACLE - Param = 6, Name = AS_SFQZF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 1784 17:40:08 SQL Data In: ORACLE - Param = 7, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 1785 17:40:08 SQL Data In: ORACLE - Param = 8, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 1786 17:40:08 SQL Data In: ORACLE - Param = 9, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1787 17:40:08 SQL Data In: ORACLE - Param = 10, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1788 17:40:08 SQL Data In: ORACLE - Param = 11, Name = ad_KFPC00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 790384.000000 1789 17:40:08 SQL Execute: ORACLE - BEGIN "SP_SF_YFCF00" (AS_CFLSH0 => :AS_CFLSH0,AD_DJH000 => :AD_DJH000,AD_SFCKBH => :AD_SFCKBH,AD_PYCKBH => :AD_PYCKBH,AD_FYCKBH => :AD_FYCKBH,AS_SFQZF0 => :AS_SFQZF0,AD_CZY000 => :AD_CZY000,AD_CZYKS0 => :AD_CZYKS0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,ad_KFPC00 => :ad_KFPC00); END; 1790 17:40:08 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6194541 1791 17:40:08 SQL Data In: ORACLE - Param = 2, Name = PDJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1792 17:40:08 SQL Data In: ORACLE - Param = 3, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933588.000000 1793 17:40:08 SQL Data In: ORACLE - Param = 4, Name = PYBDJH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1520193 1794 17:40:08 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 1795 17:40:08 SQL Data In: ORACLE - Param = 6, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 1796 17:40:08 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 1797 17:40:08 SQL Data In: ORACLE - Param = 8, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1798 17:40:08 SQL Data In: ORACLE - Param = 9, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1799 17:40:08 SQL Data In: ORACLE - Param = 10, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1800 17:40:08 SQL Execute: ORACLE - BEGIN "SP_SF_FYJS00_JZDH00" (PCFLSH0 => :PCFLSH0,PDJLB00 => :PDJLB00,PJZDH00 => :PJZDH00,PYBDJH0 => :PYBDJH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 1801 17:40:08 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 37858399 1802 17:40:08 SQL Data In: ORACLE - Param = 2, Name = PDJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1803 17:40:08 SQL Data In: ORACLE - Param = 3, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933588.000000 1804 17:40:08 SQL Data In: ORACLE - Param = 4, Name = PYBDJH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1520193 1805 17:40:08 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 1806 17:40:08 SQL Data In: ORACLE - Param = 6, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 1807 17:40:08 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 1808 17:40:08 SQL Data In: ORACLE - Param = 8, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1809 17:40:08 SQL Data In: ORACLE - Param = 9, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1810 17:40:08 SQL Data In: ORACLE - Param = 10, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1811 17:40:08 SQL Execute: ORACLE - BEGIN "SP_SF_FYJS00_JZDH00" (PCFLSH0 => :PCFLSH0,PDJLB00 => :PDJLB00,PJZDH00 => :PJZDH00,PYBDJH0 => :PYBDJH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 1812 17:40:08 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6194541 1813 17:40:08 SQL Data In: ORACLE - Param = 2, Name = PDJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 1814 17:40:08 SQL Data In: ORACLE - Param = 3, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933588.000000 1815 17:40:08 SQL Data In: ORACLE - Param = 4, Name = PYBDJH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1520193 1816 17:40:08 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 1817 17:40:08 SQL Data In: ORACLE - Param = 6, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 1818 17:40:08 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 1819 17:40:08 SQL Data In: ORACLE - Param = 8, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1820 17:40:08 SQL Data In: ORACLE - Param = 9, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1821 17:40:08 SQL Data In: ORACLE - Param = 10, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1822 17:40:08 SQL Execute: ORACLE - BEGIN "SP_SF_FYJS00_JZDH00" (PCFLSH0 => :PCFLSH0,PDJLB00 => :PDJLB00,PJZDH00 => :PJZDH00,PYBDJH0 => :PYBDJH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 1823 17:40:08 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1520193 1824 17:40:08 SQL Data In: ORACLE - Param = 2, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933588.000000 1825 17:40:08 SQL Data In: ORACLE - Param = 3, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 1826 17:40:08 SQL Data In: ORACLE - Param = 4, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 1827 17:40:08 SQL Data In: ORACLE - Param = 5, Name = AS_ICKH00, Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBK51787670 1828 17:40:08 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1829 17:40:08 SQL Data In: ORACLE - Param = 7, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 1830 17:40:08 SQL Data In: ORACLE - Param = 8, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 王卫华 1831 17:40:08 SQL Data In: ORACLE - Param = 9, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 1832 17:40:08 SQL Data In: ORACLE - Param = 10, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 1833 17:40:08 SQL Data In: ORACLE - Param = 11, Name = AD_BRZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 170.890000 1834 17:40:08 SQL Data In: ORACLE - Param = 12, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1835 17:40:08 SQL Data In: ORACLE - Param = 13, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1836 17:40:08 SQL Data In: ORACLE - Param = 14, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 170.890000 1837 17:40:08 SQL Data In: ORACLE - Param = 15, Name = AD_JMJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1838 17:40:08 SQL Data In: ORACLE - Param = 16, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 6 1839 17:40:08 SQL Data In: ORACLE - Param = 17, Name = AS_YBJZRQ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 1840 17:40:08 SQL Data In: ORACLE - Param = 18, Name = AS_YBJZSJ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 1841 17:40:08 SQL Data In: ORACLE - Param = 19, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 170.890000 1842 17:40:08 SQL Data In: ORACLE - Param = 20, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 1843 17:40:08 SQL Data In: ORACLE - Param = 21, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 王勇 1844 17:40:08 SQL Data In: ORACLE - Param = 22, Name = AD_JZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 1845 17:40:08 SQL Data In: ORACLE - Param = 23, Name = AS_JMYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1846 17:40:08 SQL Data In: ORACLE - Param = 24, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1847 17:40:08 SQL Data In: ORACLE - Param = 25, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1848 17:40:08 SQL Data In: ORACLE - Param = 26, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 1849 17:40:08 SQL Data In: ORACLE - Param = 27, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = M01600 1850 17:40:08 SQL Data In: ORACLE - Param = 28, Name = AS_SFDYFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 1851 17:40:08 SQL Data In: ORACLE - Param = 29, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1852 17:40:08 SQL Data In: ORACLE - Param = 30, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1853 17:40:08 SQL Data In: ORACLE - Param = 31, Name = AS_SFSCJS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 1854 17:40:08 SQL Data In: ORACLE - Param = 32, Name = AS_BYCS00, Type = fldZSTRING, Precision = 19, Scale = 0, Data = 01 1855 17:40:08 SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_JS0000" (AS_YBDJH0 => :AS_YBDJH0,AD_JZDH00 => :AD_JZDH00,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_ICKH00 => :AS_ICKH00,AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AD_BRFB00 => :AD_BRFB00,AD_BRZJE0 => :AD_BRZJE0,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AD_HJJE00 => :AD_HJJE00,AD_JMJE00 => :AD_JMJE00,AS_ZPZH00 => :AS_ZPZH00,AS_YBJZRQ => :AS_YBJZRQ,AS_YBJZSJ => :AS_YBJZSJ,AD_ZFJE00 => :AD_ZFJE00,AD_JZY000 => :AD_JZY000,AS_JZYXM0 => :AS_JZYXM0,AD_JZYKS0 => :AD_JZYKS0,AS_JMYY00 => :AS_JMYY00,AS_YJJXH0 => :AS_YJJXH0,AS_CZBZ00 => :AS_CZBZ00,AS_SFYB00 => :AS_SFYB00,AS_TSBZBH => :AS_TSBZBH,AS_SFDYFP => :AS_SFDYFP,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_SFSCJS => :AS_SFSCJS,AS_BYCS00 => :AS_BYCS00); END; 1856 17:40:08 SQL Execute: ORACLE - commit 1857 17:40:08 SQL Data In: ORACLE - Rows affected = 0 1858 17:40:08 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'YBJYDZ_MZ' 1859 17:40:08 SQL Execute: ORACLE - select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='YBXJKSQM' 1860 17:40:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置 1861 17:40:08 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 1862 17:40:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 1863 17:40:08 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 1864 17:40:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 1865 17:40:08 SQL Execute: ORACLE - select B.YBYHBM,B.YBYHMM from BM_BMBM00 A,XT_YYXX00 B where A.YYID00=B.YYID00 and A.BMBH00=? 1866 17:40:08 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from dual 1867 17:40:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBDZ_0000 1868 17:40:08 SQL Execute: ORACLE - Select * from BM_TYCJBM where CJBM00=? 1869 17:40:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1870 17:40:08 SQL Execute: ORACLE - Select a.YBKH00,a.YBID00,a.BRXM00,a.BRXB00,a.BRZJBH,a.FBBH00,a.YBKSBM from bm_brxxb0 a where a.brid00=? 1871 17:40:08 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual 1872 17:40:08 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('YBJK202110091740075931623924','新医保接口','Y29766229335882933588门诊结算交易对账010') 1873 17:40:08 SQL Data In: ORACLE - Rows affected = 1 1874 17:40:08 SQL Data In: ORACLE - Param = 1, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBDZ_0000 1875 17:40:08 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1876 17:40:08 SQL Data In: ORACLE - Param = 3, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1877 17:40:08 SQL Data In: ORACLE - Param = 4, Name = PGHH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1878 17:40:08 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 1879 17:40:08 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 王勇 1880 17:40:08 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 1881 17:40:08 SQL Data In: ORACLE - Param = 8, Name = PQQCSID, Type = fldZSTRING, Precision = 28, Scale = 0, Data = YBJK202110091740075931623924 1882 17:40:08 SQL Data In: ORACLE - Param = 9, Name = PINCS00, Type = fldZSTRING, Precision = 227, Scale = 0, Data = Y29766229335882933588门诊结算交易对账010 1883 17:40:08 SQL Data In: ORACLE - Param = 10, Name = POTHER0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 门诊结算交易对账 1884 17:40:08 SQL Data In: ORACLE - Param = 11, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 1885 17:40:08 SQL Data In: ORACLE - Param = 12, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1886 17:40:08 SQL Data In: ORACLE - Param = 13, Name = PYBJKID, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1887 17:40:08 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1888 17:40:08 SQL Execute: ORACLE - BEGIN "SP_SF_NEWYBJK_YBJKRZ" (PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PGHID00 => :PGHID00,PGHH000 => :PGHH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PYBJKID => :PYBJKID,PERRMSG => :PERRMSG); END; 1889 17:40:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 1890 17:40:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419756 1891 17:40:08 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284 1892 17:40:08 SQL Execute: ORACLE - update SF_YBJKMX set JKFSZ0=? where YBJKID=? and ZDBM00=? 1893 17:40:08 SQL Data In: ORACLE - Rows affected = 0 1894 17:40:08 SQL Execute: ORACLE - COMMIT 1895 17:40:08 SQL Data In: ORACLE - Rows affected = 0 1896 17:40:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419756 1897 17:40:08 SQL Execute: ORACLE - select count(distinct(JDBM00)) as Num from SF_YBJKMX where YBJKID=? and ZJDBM0='data' 1898 17:40:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419756 1899 17:40:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main 1900 17:40:08 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 1901 17:40:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419756 1902 17:40:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 1903 17:40:08 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 1904 17:40:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419756 1905 17:40:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main 1906 17:40:08 SQL Execute: ORACLE - Select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('2','3') order by JKMXID 1907 17:40:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1908 17:40:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419756 1909 17:40:08 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = flag 1910 17:40:08 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 1911 17:40:08 SQL Data In: ORACLE - Rows affected = 1 1912 17:40:08 SQL Execute: ORACLE - COMMIT 1913 17:40:08 SQL Data In: ORACLE - Rows affected = 0 1914 17:40:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 1915 17:40:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419756 1916 17:40:08 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = cause 1917 17:40:08 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 1918 17:40:08 SQL Data In: ORACLE - Rows affected = 1 1919 17:40:08 SQL Execute: ORACLE - COMMIT 1920 17:40:08 SQL Data In: ORACLE - Rows affected = 0 1921 17:40:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419756 1922 17:40:08 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 1923 17:40:08 SQL Execute: ORACLE - Select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('2','3') order by JKMXID 1924 17:40:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 1925 17:40:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 1926 17:40:09 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 1927 17:40:09 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 1928 17:40:09 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 185, Scale = 0, Data = {"usr":"350000010835000000001","pwd":"yblw888888","funid":"yb04.07.03.05","data":{"aka078":"10","akc190":"4985839","aae072":"1520193","bke298":"419755","bka555":"01","aab301":"359900"}} 1929 17:40:09 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 54, Scale = 0, Data = {"traceid":"","flag":"1","data":{},"cause":"操作成功"} 1930 17:40:09 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419756 1931 17:40:09 SQL Execute: ORACLE - update SF_YBJKRZ set DLLZT0=?,DLLERR=?,FLAG=?,CAUSE=?,JKQQCS=?,JKFHCS=? where YBJKID=? 1932 17:40:09 SQL Data In: ORACLE - Rows affected = 1 1933 17:40:09 SQL Execute: ORACLE - COMMIT 1934 17:40:09 SQL Data In: ORACLE - Rows affected = 0 1935 17:40:09 SQL Data In: ORACLE - Param = 1, Name = PYBJKID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419756 1936 17:40:09 SQL Data In: ORACLE - Param = 2, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBDZ_0000 1937 17:40:09 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1938 17:40:09 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 1939 17:40:09 SQL Data In: ORACLE - Param = 5, Name = PGHH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 1940 17:40:09 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 1941 17:40:09 SQL Data In: ORACLE - Param = 7, Name = PCZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 王勇 1942 17:40:09 SQL Data In: ORACLE - Param = 8, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 1943 17:40:09 SQL Data In: ORACLE - Param = 9, Name = PQQCSID, Type = fldZSTRING, Precision = 28, Scale = 0, Data = YBJK202110091740075931623924 1944 17:40:09 SQL Data In: ORACLE - Param = 10, Name = PINCS00, Type = fldZSTRING, Precision = 227, Scale = 0, Data = Y29766229335882933588门诊结算交易对账010 1945 17:40:09 SQL Data In: ORACLE - Param = 11, Name = POTHER0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 门诊结算交易对账 1946 17:40:09 SQL Data In: ORACLE - Param = 12, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 1947 17:40:09 SQL Data In: ORACLE - Param = 13, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1948 17:40:09 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1949 17:40:09 SQL Execute: ORACLE - BEGIN "SP_SF_NEWYBJK_YBJKQR" (PYBJKID => :PYBJKID,PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PGHID00 => :PGHID00,PGHH000 => :PGHH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PERRMSG => :PERRMSG); END; 1950 17:40:09 SQL Execute: ORACLE - COMMIT 1951 17:40:09 SQL Data In: ORACLE - Rows affected = 0 1952 17:40:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1953 17:40:09 SQL Execute: ORACLE - select SF_SF_GETKYJE(a.BRID00,1,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,a.* from sf_brzhxx a where jflbid = 1 and brid00=? 1954 17:40:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1955 17:40:09 SQL Execute: ORACLE - select SF_SF_GETKYJE(a.BRID00,1,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,a.* from sf_brzhxx a where jflbid = 1 and brid00=? 1956 17:40:09 SQL Execute: ORACLE - select SF_XT_GETTDBRTSXX('0',297662.00,0.00,'FYJS',2.00,'1') as FHTSXX from dual 1957 17:40:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933588.000000 1958 17:40:09 SQL Execute: ORACLE - select a.PJH000,b.PJXH00 from sf_jzb000 a,sf_pjsyqk b where a.jzdh00=? and a.pjh000=b.pjh000 and brzje0 > 0 1959 17:40:09 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '第三方电子发票平台接口' and BH0000 = 'printDZFP_MZ' 1960 17:40:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8973328 1961 17:40:12 SQL Execute: ORACLE - select * from VW_SF_ZZFPXX where PJH000 = ? 1962 17:40:12 SQL Execute: ORACLE - select 1239 as UserId,'100050' as UserCode,'王勇' as UserName,493 as UserLogDepId,'门诊收费处' as UserLogDepName, '4' as UserLogSysCode,'门诊收费管理系统' as UserLogSysName,'220035' as HospitalCode,'福建省老年医院' as HospitalName, '220035' as UserLogDepYYID,'福建省老年医院' as UserLogDepYYMC from dual 1963 17:40:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1964 17:40:14 SQL Execute: ORACLE - select SF_SF_GETKYJE(a.BRID00,1,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,a.* from sf_brzhxx a where jflbid = 1 and brid00=? 1965 17:40:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 1966 17:40:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBK51787670 1967 17:40:14 SQL Execute: ORACLE - select a.* from VW_SF_BRZHXX a where a.SFDJ00<>'2' and a.JFLBID = ? and a.ICKH00 = ? 1968 17:40:14 SQL Execute: ORACLE - select SF_SF_GETBRDGZFYBZ(297662,493,0) as FYGZBZ from dual 1969 17:40:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1970 17:40:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 1971 17:40:14 SQL Execute: ORACLE - select E.CSLX00,A.KHRQ00,A.XJYE00,A.ZZYE00,A.YXQFJE,A.TYJE00,SF_SF_GETKYJE(A.BRID00,1,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,B.JFLBMC,D.FBMC00,e.YBMC00, C.BRCSRQ,C.FBBH00,C.BRZJBH,C.BRBLH0,C.BRXM00,C.BRXB00,C.YBKH00,C.YBID00,C.YBLB00,C.YBBRLB,C.BRZTQK from SF_BRZHXX A,BM_BRJFLB B,BM_BRXXB0 C,bm_brfbb0 D,ic_ybbrlb E where A.JFLBID = B.JFLBID and C.FBBH00 = D.FBBH00 and C.fbbh00=E.fbbh00 and C.yblb00=E.yblb00 and A.BRID00 = C.BRID00 and A.SFDJ00 <> '2' and A.BRID00 = ? and A.JFLBID = ? 1972 17:40:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1973 17:40:14 SQL Execute: ORACLE - select TBLBMC from VW_BM_BRXXB2 where BRID00 =? 1974 17:40:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1975 17:40:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 1976 17:40:14 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 1977 17:40:14 SQL Execute: ORACLE - select CFLSH0 from YF_MZCF00 where BRID00=? and CFZT00 = '0' and SRRQ00>= ? and SRRQ00<= ? 1978 17:40:14 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6194619 1979 17:40:14 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 1980 17:40:14 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 1981 17:40:14 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 1982 17:40:14 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 1983 17:40:14 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1984 17:40:14 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 1985 17:40:14 SQL Execute: ORACLE - BEGIN "SP_SF_JSCFJG" (PCFLSH0 => :PCFLSH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 1986 17:40:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1987 17:40:14 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 1988 17:40:14 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 1989 17:40:14 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 1990 17:40:14 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000000001.000000 1991 17:40:14 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1992 17:40:14 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 1993 17:40:14 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 1994 17:40:14 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 1995 17:40:14 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 1996 17:40:14 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 1997 17:40:14 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 1998 17:40:14 SQL Execute: ORACLE - select * from ( select a.GHH000,a.FPXMMC,a.XMMC00,a.XMDJ00,a.XMDW00,a.XMSL00,a.HJJE00,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.KDKSMC,a.KDYSXM,a.DJH000,a.TSBZBH,a.TSBZMC,a.ZLXMJC, a.MZFPID,a.JZBZ00,a.JZJE00,a.GFJE00,to_char(a.YJDJH0) as YJDJH0,a.SFLB00,a.MXID00,a.CXBZ00,a.OMXID0,a.CFDGS0,a.ZXKSMC, a.CZRQ00,a.JZZTMC,a.TCNWJC,nvl(a.TCID00,0) as TCID00,a.TCXMMC from VW_SF_WJSFYMX a where a.BRID00 = ? and a.JFLBID = ? and a.CZRQ00>= ? and a.CZRQ00<= ? and a.XMBH00+0 <> ? union all select a.GHH000,a.FPXMMC,a.SFXMMC,a.XMDJ00,a.XMDW00,a.XMSL00,a.AMOUNT,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.BMMC00 KDKSMC,a.KDYSXM,0 DJH000,a.TSBZBH,a.TSBZMC,a.ZLXMJC, a.FPXMID,a.JZBZ00,a.JZJE00,a.GFJE00,to_char(A.YJDJH0),a.JSXM00 SFLB00,a.ID0000 MXID00,'Z',0,a.CFDGS0,a.YJKSMC, a.KDRQ00,a.JZZTMC,'' as TCNWJC,nvl(a.TCID00,0) as TCID00,a.TCXMMC from VW_SF_YJYWMX a where a.CXDJH0 is null and A.BRID00 = ? and a.KDRQ00>= ? and a.KDRQ00<= ? union all select a.GHH000,a.FPXMMC,a.YPMC00,a.LSDJ00,a.CFDW00,a.YPZSL0,a.AMOUNT,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.KDKSMC,a.YSXM00,0 DJH000,a.TSBZBH,a.TSBZMC,FPXMMC ZLXMJC, a.FPXMID,a.JZBZ00,a.JZJE00,a.GFJE00,a.CFLSH0,a.SFLB00,CFID00 MXID00,'Z',0,a.CFDGS0,a.BMMC00, a.SRRQ00,a.JZZTMC,'' as TCNWJC,0 as TCID00,null as TCXMMC from VW_SF_CFMX00 a where a.BCCFH0 is null and a.THBZ00='0' and a.BRID00 = ? and a.SRRQ00>= ? and a.SRRQ00<= ? and a.SRRQ00>= to_char(sysdate-?,'YYYYMMDD') ) order by GHH000,JZBZ00,MZFPID,CFDGS0,YJDJH0,MXID00,ZLXMJC 1999 17:40:14 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8516590 2000 17:40:14 SQL Execute: ORACLE - select a.GHH000,substr(SF_SF_GETRQSJ(A.GHRQ00,A.GHSJ00),1,50) GHRQSJ,a.GHRQ00,b.bmmc00 GHKSMC, nvl((select YBBMMC from BM_YBKSBM where YBBMBH=b.YBKSBH and rownum=1),b.BMMC00) as YBGHKS, (select zwxm00 from BM_YGBM00 where ygbh00=a.jzys00) JZYSXM,a.GHYXM0,a.YBGHH0, (select mc0000 from VW_SF_TSBZB0 where BH0000=a.TSBZBH and YBZXLB=a.YBZXLB) TSBZMC, a.TSBZBH,a.GHKS00, (select LBMC00 from BM_GHLBB0 where LBBH00=a.GHLB00) GHLBMC,a.GHSJ00,a.BXLB00,a.GHID00, (select nvl(min(JZRQ00),a.GHRQ00) from SF_JZB000 where MZID00=a.GHID00 and HJJE00>0 and nvl(YBGHH0,'0')<>'0' and YBGHH0=a.YBGHH0) YBJZRQ,0 BCSFCS, decode((select ZDMC00 from YS_BRZDXX where GHH000=a.GHH000 and ZZDBZ0='3' and rownum=1),'',(select ZDMC00 from YS_BRZDXX where GHH000=a.GHH000 and ZZDBZ0='1' and rownum=1), (select ZDMC00 from YS_BRZDXX where GHH000=a.GHH000 and ZZDBZ0='3' and rownum=1)) as ZDMC00, a.SFCQJC from sf_brxxb0 a,BM_BMBM00 b where a.GHH000 = ? and a.GHKS00=b.bmbh00 order by a.GHID00 2001 17:40:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2002 17:40:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2003 17:40:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2004 17:40:16 SQL Execute: ORACLE - select CFLSH0 from YF_MZCF00 where BRID00=? and CFZT00 = '0' and SRRQ00>= ? and SRRQ00<= ? 2005 17:40:16 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6194619 2006 17:40:16 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2007 17:40:16 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2008 17:40:16 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 2009 17:40:16 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2010 17:40:16 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2011 17:40:16 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2012 17:40:16 SQL Execute: ORACLE - BEGIN "SP_SF_JSCFJG" (PCFLSH0 => :PCFLSH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 2013 17:40:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2014 17:40:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 2015 17:40:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2016 17:40:16 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2017 17:40:16 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000000001.000000 2018 17:40:16 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2019 17:40:16 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2020 17:40:16 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2021 17:40:16 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2022 17:40:16 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2023 17:40:16 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2024 17:40:16 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 2025 17:40:16 SQL Execute: ORACLE - select * from ( select a.GHH000,a.FPXMMC,a.XMMC00,a.XMDJ00,a.XMDW00,a.XMSL00,a.HJJE00,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.KDKSMC,a.KDYSXM,a.DJH000,a.TSBZBH,a.TSBZMC,a.ZLXMJC, a.MZFPID,a.JZBZ00,a.JZJE00,a.GFJE00,to_char(a.YJDJH0) as YJDJH0,a.SFLB00,a.MXID00,a.CXBZ00,a.OMXID0,a.CFDGS0,a.ZXKSMC, a.CZRQ00,a.JZZTMC,a.TCNWJC,nvl(a.TCID00,0) as TCID00,a.TCXMMC from VW_SF_WJSFYMX a where a.BRID00 = ? and a.JFLBID = ? and a.CZRQ00>= ? and a.CZRQ00<= ? and a.XMBH00+0 <> ? and (a.TSBZMC = '高血压病' or a.MZFPID in (4,6)) union all select a.GHH000,a.FPXMMC,a.SFXMMC,a.XMDJ00,a.XMDW00,a.XMSL00,a.AMOUNT,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.BMMC00 KDKSMC,a.KDYSXM,0 DJH000,a.TSBZBH,a.TSBZMC,a.ZLXMJC, a.FPXMID,a.JZBZ00,a.JZJE00,a.GFJE00,to_char(A.YJDJH0),a.JSXM00 SFLB00,a.ID0000 MXID00,'Z',0,a.CFDGS0,a.YJKSMC, a.KDRQ00,a.JZZTMC,'' as TCNWJC,nvl(a.TCID00,0) as TCID00,a.TCXMMC from VW_SF_YJYWMX a where a.CXDJH0 is null and A.BRID00 = ? and a.KDRQ00>= ? and a.KDRQ00<= ? and (a.TSBZMC = '高血压病' or a.FPXMID in (4,6)) union all select a.GHH000,a.FPXMMC,a.YPMC00,a.LSDJ00,a.CFDW00,a.YPZSL0,a.AMOUNT,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.KDKSMC,a.YSXM00,0 DJH000,a.TSBZBH,a.TSBZMC,FPXMMC ZLXMJC, a.FPXMID,a.JZBZ00,a.JZJE00,a.GFJE00,a.CFLSH0,a.SFLB00,CFID00 MXID00,'Z',0,a.CFDGS0,a.BMMC00, a.SRRQ00,a.JZZTMC,'' as TCNWJC,0 as TCID00,null as TCXMMC from VW_SF_CFMX00 a where a.BCCFH0 is null and a.THBZ00='0' and a.BRID00 = ? and a.SRRQ00>= ? and a.SRRQ00<= ? and a.SRRQ00>= to_char(sysdate-?,'YYYYMMDD') and (a.TSBZMC = '高血压病' or a.FPXMID in (4,6)) ) order by GHH000,JZBZ00,MZFPID,CFDGS0,YJDJH0,MXID00,ZLXMJC 2026 17:40:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2027 17:40:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 高血压病 2028 17:40:16 SQL Execute: ORACLE - select ZYYBJK,BH0000 from VW_SF_TSBZB0 where ybzxlb = ? and trim(mc0000) = ? 2029 17:40:17 SQL Execute: ORACLE - select trim(MC0000) MC0000 from BM_TYZD00 where ZDMC00 = '事前审方-事前审方系统' and BZ0000 = '是否启用审方系统' 2030 17:40:18 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS' 2031 17:40:18 SQL Execute: ORACLE - Select SYSDATE from Dual 2032 17:40:18 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') 2033 17:40:18 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') 2034 17:40:18 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') 2035 17:40:22 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBK51787670' and ICKNBH = 'FZYBK51787670' 2036 17:40:22 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='不孕症诊断字典' and YXBZ00='1' 2037 17:40:22 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDDHH24:MI:SS') OraSysDate FROM DUAL 2038 17:40:22 SQL Execute: ORACLE - Select SQ_SF_JZB000_JZDH00.NextVal Val from Dual 2039 17:40:22 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'JSSFFSYBXXZGCX' 2040 17:40:22 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'JSSFFSYBXXZGCX' 2041 17:40:22 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6194619 2042 17:40:22 SQL Data In: ORACLE - Param = 2, Name = PDJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2043 17:40:22 SQL Data In: ORACLE - Param = 3, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933589.000000 2044 17:40:22 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2045 17:40:22 SQL Data In: ORACLE - Param = 5, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2046 17:40:22 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 2047 17:40:22 SQL Data In: ORACLE - Param = 7, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2048 17:40:22 SQL Data In: ORACLE - Param = 8, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2049 17:40:22 SQL Data In: ORACLE - Param = 9, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2050 17:40:22 SQL Data In: ORACLE - Param = 10, Name = PSFXYB0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2051 17:40:22 SQL Execute: ORACLE - BEGIN "SP_SF_FYDJ00_YBJK00" (PCFLSH0 => :PCFLSH0,PDJLB00 => :PDJLB00,PJZDH00 => :PJZDH00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PSFXYB0 => :PSFXYB0); END; 2052 17:40:22 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6194619 2053 17:40:22 SQL Data In: ORACLE - Param = 2, Name = PDJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 2054 17:40:22 SQL Data In: ORACLE - Param = 3, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933589.000000 2055 17:40:22 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2056 17:40:22 SQL Data In: ORACLE - Param = 5, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2057 17:40:22 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 2058 17:40:22 SQL Data In: ORACLE - Param = 7, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2059 17:40:22 SQL Data In: ORACLE - Param = 8, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2060 17:40:22 SQL Data In: ORACLE - Param = 9, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2061 17:40:22 SQL Data In: ORACLE - Param = 10, Name = PSFXYB0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2062 17:40:22 SQL Execute: ORACLE - BEGIN "SP_SF_FYDJ00_YBJK00" (PCFLSH0 => :PCFLSH0,PDJLB00 => :PDJLB00,PJZDH00 => :PJZDH00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PSFXYB0 => :PSFXYB0); END; 2063 17:40:22 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2064 17:40:22 SQL Data In: ORACLE - Param = 2, Name = PTEMPID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2065 17:40:22 SQL Data In: ORACLE - Param = 3, Name = PGHH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2066 17:40:22 SQL Data In: ORACLE - Param = 4, Name = PJZDH00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2933589 2067 17:40:22 SQL Data In: ORACLE - Param = 5, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2068 17:40:22 SQL Data In: ORACLE - Param = 6, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2069 17:40:22 SQL Execute: ORACLE - BEGIN "SP_SF_WSPYPTS" (PBRID00 => :PBRID00,PTEMPID => :PTEMPID,PGHH000 => :PGHH000,PJZDH00 => :PJZDH00,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END; 2070 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2071 17:40:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 高血压病 2072 17:40:22 SQL Execute: ORACLE - select ZYYBJK,BH0000 from VW_SF_TSBZB0 where ybzxlb = ? and trim(mc0000) = ? 2073 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2074 17:40:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 高血压病 2075 17:40:22 SQL Execute: ORACLE - select ZYYBJK,BH0000 from VW_SF_TSBZB0 where ybzxlb = ? and trim(mc0000) = ? 2076 17:40:22 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2077 17:40:22 SQL Data In: ORACLE - Param = 2, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933589.000000 2078 17:40:22 SQL Data In: ORACLE - Param = 3, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8110614.000000 2079 17:40:22 SQL Data In: ORACLE - Param = 4, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2080 17:40:22 SQL Data In: ORACLE - Param = 5, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2081 17:40:22 SQL Data In: ORACLE - Param = 6, Name = PTSBZBH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = M03900 2082 17:40:22 SQL Data In: ORACLE - Param = 7, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2083 17:40:22 SQL Data In: ORACLE - Param = 8, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2084 17:40:22 SQL Data In: ORACLE - Param = 9, Name = PSFXYB0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2085 17:40:22 SQL Execute: ORACLE - BEGIN "SP_SF_YBJK00_FJ0000" (PBRID00 => :PBRID00,PJZDH00 => :PJZDH00,PID0000 => :PID0000,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PTSBZBH => :PTSBZBH,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PSFXYB0 => :PSFXYB0); END; 2086 17:40:22 SQL Execute: ORACLE - Commit 2087 17:40:22 SQL Data In: ORACLE - Rows affected = 0 2088 17:40:22 SQL Execute: ORACLE - select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='YBXJKSQM' 2089 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置 2090 17:40:22 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 2091 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2092 17:40:22 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 2093 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2094 17:40:22 SQL Execute: ORACLE - select B.YBYHBM,B.YBYHMM from BM_BMBM00 A,XT_YYXX00 B where A.YYID00=B.YYID00 and A.BMBH00=? 2095 17:40:22 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from dual 2096 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_MXSC_0026 2097 17:40:22 SQL Execute: ORACLE - Select * from BM_TYCJBM where CJBM00=? 2098 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2099 17:40:22 SQL Execute: ORACLE - Select a.YBKH00,a.YBID00,a.BRXM00,a.BRXB00,a.BRZJBH,a.FBBH00,a.YBKSBM from bm_brxxb0 a where a.brid00=? 2100 17:40:22 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual 2101 17:40:22 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('YBJK202110091740213591623925','新医保接口','N29766285165904985839费用结算模块M039000N8110616NBM_SFCFMX_TEMP0001') 2102 17:40:22 SQL Data In: ORACLE - Rows affected = 1 2103 17:40:22 SQL Data In: ORACLE - Param = 1, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_MXSC_0026 2104 17:40:22 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2105 17:40:22 SQL Data In: ORACLE - Param = 3, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8516590.000000 2106 17:40:22 SQL Data In: ORACLE - Param = 4, Name = PGHH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2107 17:40:22 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2108 17:40:22 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 王勇 2109 17:40:22 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2110 17:40:22 SQL Data In: ORACLE - Param = 8, Name = PQQCSID, Type = fldZSTRING, Precision = 28, Scale = 0, Data = YBJK202110091740213591623925 2111 17:40:22 SQL Data In: ORACLE - Param = 10, Name = POTHER0, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 费用结算模块 2112 17:40:22 SQL Data In: ORACLE - Param = 11, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 2113 17:40:22 SQL Data In: ORACLE - Param = 12, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2114 17:40:22 SQL Data In: ORACLE - Param = 13, Name = PYBJKID, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2115 17:40:22 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2116 17:40:22 SQL Execute: ORACLE - BEGIN "SP_SF_NEWYBJK_YBJKRZ" (PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PGHID00 => :PGHID00,PGHH000 => :PGHH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PYBJKID => :PYBJKID,PERRMSG => :PERRMSG); END; 2117 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 2118 17:40:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2119 17:40:22 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284 2120 17:40:22 SQL Execute: ORACLE - update SF_YBJKMX set JKFSZ0=? where YBJKID=? and ZDBM00=? 2121 17:40:22 SQL Data In: ORACLE - Rows affected = 1 2122 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2123 17:40:22 SQL Execute: ORACLE - select count(distinct(JDBM00)) as Num from SF_YBJKMX where YBJKID=? and ZJDBM0='data' 2124 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2125 17:40:22 SQL Execute: ORACLE - select count(1)as num from SF_YBJKQD where YBJKID=? 2126 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2127 17:40:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main 2128 17:40:22 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 2129 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2130 17:40:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 2131 17:40:22 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 2132 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2133 17:40:22 SQL Execute: ORACLE - select distinct(JDBM00) as listbm from SF_YBJKMX where YBJKID=? and ZJDBM0='data' 2134 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2135 17:40:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = zdlist 2136 17:40:22 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 2137 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2138 17:40:22 SQL Execute: ORACLE - select * from SF_YBJKQD where YBJKID=? order by JKMXID 2139 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2140 17:40:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main 2141 17:40:22 SQL Execute: ORACLE - Select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('2','3') order by JKMXID 2142 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2143 17:40:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2144 17:40:22 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = flag 2145 17:40:22 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2146 17:40:22 SQL Data In: ORACLE - Rows affected = 1 2147 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 2148 17:40:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2149 17:40:22 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = cause 2150 17:40:22 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2151 17:40:22 SQL Data In: ORACLE - Rows affected = 1 2152 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2153 17:40:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 2154 17:40:22 SQL Execute: ORACLE - Select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('2','3') order by JKMXID 2155 17:40:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 16337724247181542567 2156 17:40:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2157 17:40:22 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke297 2158 17:40:22 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2159 17:40:22 SQL Data In: ORACLE - Rows affected = 1 2160 17:40:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2161 17:40:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 2162 17:40:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2163 17:40:23 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 2164 17:40:23 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 85, Scale = 0, Data = {"traceid":"","flag":"1","data":{"bke297":"16337724247181542567"},"cause":"操作成功"} 2165 17:40:23 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2166 17:40:23 SQL Execute: ORACLE - update SF_YBJKRZ set DLLZT0=?,DLLERR=?,FLAG=?,CAUSE=?,JKQQCS=?,JKFHCS=? where YBJKID=? 2167 17:40:23 SQL Data In: ORACLE - Rows affected = 1 2168 17:40:23 SQL Data In: ORACLE - Param = 1, Name = PYBJKID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2169 17:40:23 SQL Data In: ORACLE - Param = 2, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_MXSC_0026 2170 17:40:23 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2171 17:40:23 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8516590.000000 2172 17:40:23 SQL Data In: ORACLE - Param = 5, Name = PGHH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2173 17:40:23 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2174 17:40:23 SQL Data In: ORACLE - Param = 7, Name = PCZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 王勇 2175 17:40:23 SQL Data In: ORACLE - Param = 8, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2176 17:40:23 SQL Data In: ORACLE - Param = 9, Name = PQQCSID, Type = fldZSTRING, Precision = 28, Scale = 0, Data = YBJK202110091740213591623925 2177 17:40:23 SQL Data In: ORACLE - Param = 11, Name = POTHER0, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 费用结算模块 2178 17:40:23 SQL Data In: ORACLE - Param = 12, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 2179 17:40:23 SQL Data In: ORACLE - Param = 13, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2180 17:40:23 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2181 17:40:23 SQL Execute: ORACLE - BEGIN "SP_SF_NEWYBJK_YBJKQR" (PYBJKID => :PYBJKID,PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PGHID00 => :PGHID00,PGHH000 => :PGHH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PERRMSG => :PERRMSG); END; 2182 17:40:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419757 2183 17:40:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke297 2184 17:40:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2185 17:40:23 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual 2186 17:40:23 SQL Execute: ORACLE - select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='YBXJKSQM' 2187 17:40:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置 2188 17:40:23 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 2189 17:40:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2190 17:40:23 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 2191 17:40:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2192 17:40:23 SQL Execute: ORACLE - select B.YBYHBM,B.YBYHMM from BM_BMBM00 A,XT_YYXX00 B where A.YYID00=B.YYID00 and A.BMBH00=? 2193 17:40:23 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from dual 2194 17:40:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_TYSF_0020 2195 17:40:23 SQL Execute: ORACLE - Select * from BM_TYCJBM where CJBM00=? 2196 17:40:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2197 17:40:23 SQL Execute: ORACLE - Select a.YBKH00,a.YBID00,a.BRXM00,a.BRXB00,a.BRZJBH,a.FBBH00,a.YBKSBM from bm_brxxb0 a where a.brid00=? 2198 17:40:23 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual 2199 17:40:23 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('YBJK202110091740223591623926','新医保接口','N2976628516590498583916337724247181542567费用结算模块M039008110616NBM_SFCFMX_TEMP000N01') 2200 17:40:23 SQL Data In: ORACLE - Rows affected = 1 2201 17:40:23 SQL Data In: ORACLE - Param = 1, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_TYSF_0020 2202 17:40:23 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2203 17:40:23 SQL Data In: ORACLE - Param = 3, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8516590.000000 2204 17:40:23 SQL Data In: ORACLE - Param = 4, Name = PGHH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2205 17:40:23 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2206 17:40:23 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 王勇 2207 17:40:23 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2208 17:40:23 SQL Data In: ORACLE - Param = 8, Name = PQQCSID, Type = fldZSTRING, Precision = 28, Scale = 0, Data = YBJK202110091740223591623926 2209 17:40:23 SQL Data In: ORACLE - Param = 10, Name = POTHER0, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 费用结算模块 2210 17:40:23 SQL Data In: ORACLE - Param = 11, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 2211 17:40:23 SQL Data In: ORACLE - Param = 12, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2212 17:40:23 SQL Data In: ORACLE - Param = 13, Name = PYBJKID, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2213 17:40:23 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2214 17:40:23 SQL Execute: ORACLE - BEGIN "SP_SF_NEWYBJK_YBJKRZ" (PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PGHID00 => :PGHID00,PGHH000 => :PGHH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PYBJKID => :PYBJKID,PERRMSG => :PERRMSG); END; 2215 17:40:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 2216 17:40:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2217 17:40:23 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284 2218 17:40:23 SQL Execute: ORACLE - update SF_YBJKMX set JKFSZ0=? where YBJKID=? and ZDBM00=? 2219 17:40:23 SQL Data In: ORACLE - Rows affected = 1 2220 17:40:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2221 17:40:23 SQL Execute: ORACLE - select count(distinct(JDBM00)) as Num from SF_YBJKMX where YBJKID=? and ZJDBM0='data' 2222 17:40:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2223 17:40:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main 2224 17:40:23 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 2225 17:40:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2226 17:40:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 2227 17:40:23 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 2228 17:40:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2229 17:40:23 SQL Execute: ORACLE - select distinct(JDBM00) as listbm from SF_YBJKMX where YBJKID=? and ZJDBM0='data' 2230 17:40:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2231 17:40:23 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = cflist 2232 17:40:23 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 2233 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2234 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main 2235 17:40:28 SQL Execute: ORACLE - Select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('2','3') order by JKMXID 2236 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2237 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2238 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = flag 2239 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2240 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2241 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 2242 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2243 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = cause 2244 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2245 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2246 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2247 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 2248 17:40:28 SQL Execute: ORACLE - Select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('2','3') order by JKMXID 2249 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = K51787670 2250 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2251 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aaz500 2252 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2253 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2254 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 王卫华 2255 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2256 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac003 2257 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2258 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2259 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 359900 2260 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2261 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aab301 2262 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2263 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2264 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 35260119630705001X 2265 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2266 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac999 2267 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2268 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2269 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2270 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2271 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac004 2272 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2273 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2274 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19630705 2275 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2276 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aac006 2277 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2278 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2279 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = M03900 2280 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2281 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aaz149 2282 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2283 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2284 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 10 2285 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2286 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aka078 2287 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2288 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2289 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 14 2290 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2291 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aka130 2292 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2293 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2294 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4985839 2295 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2296 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = akc190 2297 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2298 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2299 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 105.51 2300 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2301 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = akc087 2302 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2303 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2304 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2305 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2306 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc591 2307 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2308 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2309 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2310 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2311 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke298 2312 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2313 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2314 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2315 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2316 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc014 2317 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2318 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2319 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 000000 2320 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2321 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc171 2322 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2323 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2324 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 97.93 2325 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2326 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = akc227 2327 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2328 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2329 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1520207 2330 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2331 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aae072 2332 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2333 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2334 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2335 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2336 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aka151 2337 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2338 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2339 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2340 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2341 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc040 2342 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2343 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2344 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 17.25 2345 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2346 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc041 2347 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2348 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2349 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 80.68 2350 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2351 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc102 2352 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2353 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2354 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 80.68 2355 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2356 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc045 2357 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2358 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2359 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2360 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2361 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc052 2362 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2363 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2364 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2365 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2366 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc059 2367 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2368 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2369 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2370 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2371 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc134 2372 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2373 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2374 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2375 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2376 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke856 2377 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2378 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2379 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 0.0 2380 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2381 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc062 2382 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2383 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2384 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 0.0 2385 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2386 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc060 2387 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2388 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2389 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 0.0 2390 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2391 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ake173 2392 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2393 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2394 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2395 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2396 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ake026 2397 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2398 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2399 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2400 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2401 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc075 2402 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2403 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2404 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 0.0 2405 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2406 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc011 2407 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2408 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2409 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2410 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2411 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aka150 2412 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2413 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2414 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2415 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2416 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ake007 2417 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2418 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2419 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 000000 2420 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2421 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bae029 2422 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2423 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2424 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2425 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2426 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc620 2427 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2428 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2429 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2430 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2431 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc619 2432 17:40:28 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2433 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2434 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2435 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 2436 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = fplist 2437 17:40:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = fplist 2438 17:40:28 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 医保发票费用 2439 17:40:28 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 2440 17:40:28 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 2441 17:40:28 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 153, Scale = 0, Data = 其他费0.00.03.0194.9297.9313 2442 17:40:28 SQL Execute: ORACLE - insert into SF_YBJKMX(YBJKID,JKMXID,JDBM00,ZJDBM0,ZDBM00,ZDMC00,FSLXBZ,ZDLX00,VALUE0) select ?,SQ_SF_YBJKMX_JKMXID.nextval,?,?,?,?,?,?,? from dual 2443 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2444 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2445 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 2446 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2447 17:40:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 2448 17:40:28 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2449 17:40:28 SQL Execute: ORACLE - update SF_YBJKRZ set DLLZT0=?,DLLERR=?,FLAG=?,CAUSE=?,JKQQCS=?,JKFHCS=? where YBJKID=? 2450 17:40:28 SQL Data In: ORACLE - Rows affected = 1 2451 17:40:28 SQL Data In: ORACLE - Param = 1, Name = PYBJKID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2452 17:40:28 SQL Data In: ORACLE - Param = 2, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_TYSF_0020 2453 17:40:28 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2454 17:40:28 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8516590.000000 2455 17:40:28 SQL Data In: ORACLE - Param = 5, Name = PGHH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2456 17:40:28 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2457 17:40:28 SQL Data In: ORACLE - Param = 7, Name = PCZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 王勇 2458 17:40:28 SQL Data In: ORACLE - Param = 8, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2459 17:40:28 SQL Data In: ORACLE - Param = 9, Name = PQQCSID, Type = fldZSTRING, Precision = 28, Scale = 0, Data = YBJK202110091740223591623926 2460 17:40:28 SQL Data In: ORACLE - Param = 11, Name = POTHER0, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 费用结算模块 2461 17:40:28 SQL Data In: ORACLE - Param = 12, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 2462 17:40:28 SQL Data In: ORACLE - Param = 13, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2463 17:40:28 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2464 17:40:28 SQL Execute: ORACLE - BEGIN "SP_SF_NEWYBJK_YBJKQR" (PYBJKID => :PYBJKID,PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PGHID00 => :PGHID00,PGHH000 => :PGHH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PERRMSG => :PERRMSG); END; 2465 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2466 17:40:28 SQL Execute: ORACLE - select * from VW_SF_YBJKRZ where YBJKID=? 2467 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2468 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc054 2469 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2470 17:40:28 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2471 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2472 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aaz149 2473 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2474 17:40:28 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual 2475 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2476 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ake007 2477 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2478 17:40:28 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual 2479 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2480 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bae029 2481 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2482 17:40:28 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual 2483 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2484 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284 2485 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2486 17:40:28 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual 2487 17:40:28 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL99' and YBZDBM is not null order by YBYLZD 2488 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2489 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc076 2490 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2491 17:40:28 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2492 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2493 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc079 2494 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2495 17:40:28 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2496 17:40:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2497 17:40:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc075 2498 17:40:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2499 17:40:28 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2500 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2501 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc591 2502 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2503 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2504 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2505 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = drgzfe 2506 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2507 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2508 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2509 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = jzfp01 2510 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2511 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2512 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2513 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = jzfp02 2514 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2515 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2516 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2517 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = jzfp03 2518 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2519 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2520 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2521 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = csjz00 2522 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2523 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2524 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2525 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = akc227 2526 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2527 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2528 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2529 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc102 2530 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2531 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2532 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2533 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc040 2534 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2535 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2536 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2537 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc041 2538 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2539 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2540 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2541 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc045 2542 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2543 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2544 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2545 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc059 2546 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2547 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2548 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2549 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc052 2550 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2551 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2552 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2553 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc062 2554 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2555 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2556 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2557 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc060 2558 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2559 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2560 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2561 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ake173 2562 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2563 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2564 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2565 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = ake026 2566 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2567 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2568 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2569 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc011 2570 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2571 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2572 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2573 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = akc087 2574 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2575 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2576 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2577 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aka151 2578 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2579 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2580 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2581 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aka150 2582 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2583 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2584 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2585 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc612 2586 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2587 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2588 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2589 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bkc064 2590 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2591 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX_NUM(?,?,?) as FHXX00 from dual 2592 17:40:29 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBSM01' and YBYLZD<='YBSM50' and YBZDBM is not null order by YBYLZD 2593 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2594 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = aaz149 2595 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2596 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual 2597 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2598 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = jsbllx 2599 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2600 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual 2601 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2602 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bka188 2603 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2604 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual 2605 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2606 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bka555 2607 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2608 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYBJKMX(?,?,?) as FHXX00 from dual 2609 17:40:29 SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8110616.000000 2610 17:40:29 SQL Data In: ORACLE - Param = 2, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933589.000000 2611 17:40:29 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2612 17:40:29 SQL Data In: ORACLE - Param = 4, Name = PCFMXS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2613 17:40:29 SQL Data In: ORACLE - Param = 5, Name = PYBZHYE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 105.510000 2614 17:40:29 SQL Data In: ORACLE - Param = 6, Name = PYBDJH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1520207 2615 17:40:29 SQL Data In: ORACLE - Param = 7, Name = PBCBXF0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 97.930000 2616 17:40:29 SQL Data In: ORACLE - Param = 8, Name = PJJZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 80.680000 2617 17:40:29 SQL Data In: ORACLE - Param = 9, Name = PZHZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17.250000 2618 17:40:29 SQL Data In: ORACLE - Param = 10, Name = PDBZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2619 17:40:29 SQL Data In: ORACLE - Param = 11, Name = PDBJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2620 17:40:29 SQL Data In: ORACLE - Param = 12, Name = PSYBXZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2621 17:40:29 SQL Data In: ORACLE - Param = 13, Name = PBJJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2622 17:40:29 SQL Data In: ORACLE - Param = 14, Name = PSBZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2623 17:40:29 SQL Data In: ORACLE - Param = 15, Name = PBJZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2624 17:40:29 SQL Data In: ORACLE - Param = 16, Name = PGWYBZ0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2625 17:40:29 SQL Data In: ORACLE - Param = 17, Name = PDBGRZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2626 17:40:29 SQL Data In: ORACLE - Param = 18, Name = PGRZFE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2627 17:40:29 SQL Data In: ORACLE - Param = 19, Name = PBCKBCS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2628 17:40:29 SQL Data In: ORACLE - Param = 20, Name = PFYBFY0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2629 17:40:29 SQL Data In: ORACLE - Param = 21, Name = PYLZFJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2630 17:40:29 SQL Data In: ORACLE - Param = 22, Name = PCFDXJE, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2631 17:40:29 SQL Data In: ORACLE - Param = 23, Name = PTSBZBH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = M03900 2632 17:40:29 SQL Data In: ORACLE - Param = 24, Name = PYBSFRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2633 17:40:29 SQL Data In: ORACLE - Param = 25, Name = PYBSFSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 2634 17:40:29 SQL Data In: ORACLE - Param = 26, Name = PCXBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 2635 17:40:29 SQL Data In: ORACLE - Param = 27, Name = PCXJZDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2636 17:40:29 SQL Data In: ORACLE - Param = 28, Name = PTMLJ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2637 17:40:29 SQL Data In: ORACLE - Param = 29, Name = PYBGHH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4985839 2638 17:40:29 SQL Data In: ORACLE - Param = 30, Name = PZYYBJK, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 2639 17:40:29 SQL Data In: ORACLE - Param = 31, Name = PBXLB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2640 17:40:29 SQL Data In: ORACLE - Param = 32, Name = PMXZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2641 17:40:29 SQL Data In: ORACLE - Param = 33, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2642 17:40:29 SQL Data In: ORACLE - Param = 34, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2643 17:40:29 SQL Data In: ORACLE - Param = 35, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 2644 17:40:29 SQL Data In: ORACLE - Param = 36, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2645 17:40:29 SQL Data In: ORACLE - Param = 37, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2646 17:40:29 SQL Data In: ORACLE - Param = 38, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2647 17:40:29 SQL Data In: ORACLE - Param = 39, Name = PYBYL01, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2648 17:40:29 SQL Data In: ORACLE - Param = 40, Name = PYBYL02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2649 17:40:29 SQL Data In: ORACLE - Param = 41, Name = PYBYL03, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2650 17:40:29 SQL Data In: ORACLE - Param = 42, Name = PYBYL04, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2651 17:40:29 SQL Data In: ORACLE - Param = 43, Name = PYBYL05, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2652 17:40:29 SQL Data In: ORACLE - Param = 44, Name = PYBYL06, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2653 17:40:29 SQL Data In: ORACLE - Param = 45, Name = PYBYL07, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2654 17:40:29 SQL Data In: ORACLE - Param = 46, Name = PYBYL08, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2655 17:40:29 SQL Data In: ORACLE - Param = 47, Name = PYBYL09, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2656 17:40:29 SQL Data In: ORACLE - Param = 48, Name = PYBYL10, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2657 17:40:29 SQL Data In: ORACLE - Param = 49, Name = PYBYL11, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2658 17:40:29 SQL Data In: ORACLE - Param = 50, Name = PYBYL12, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2659 17:40:29 SQL Data In: ORACLE - Param = 51, Name = PYBYL13, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2660 17:40:29 SQL Data In: ORACLE - Param = 52, Name = PYBYL14, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2661 17:40:29 SQL Data In: ORACLE - Param = 53, Name = PYBYL15, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2662 17:40:29 SQL Data In: ORACLE - Param = 54, Name = PYBYL16, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2663 17:40:29 SQL Data In: ORACLE - Param = 55, Name = PYBYL17, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2664 17:40:29 SQL Data In: ORACLE - Param = 56, Name = PYBYL18, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2665 17:40:29 SQL Data In: ORACLE - Param = 57, Name = PYBYL19, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2666 17:40:29 SQL Data In: ORACLE - Param = 58, Name = PYBYL20, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2667 17:40:29 SQL Data In: ORACLE - Param = 59, Name = PYBYL21, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2668 17:40:29 SQL Data In: ORACLE - Param = 60, Name = PYBYL22, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2669 17:40:29 SQL Data In: ORACLE - Param = 61, Name = PYBYL23, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2670 17:40:29 SQL Data In: ORACLE - Param = 62, Name = PYBYL24, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2671 17:40:29 SQL Data In: ORACLE - Param = 63, Name = PYBYL25, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2672 17:40:29 SQL Data In: ORACLE - Param = 64, Name = PYBYL26, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2673 17:40:29 SQL Data In: ORACLE - Param = 65, Name = PYBYL27, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2674 17:40:29 SQL Data In: ORACLE - Param = 66, Name = PYBYL28, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2675 17:40:29 SQL Data In: ORACLE - Param = 67, Name = PYBYL29, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2676 17:40:29 SQL Data In: ORACLE - Param = 68, Name = PYBYL30, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2677 17:40:29 SQL Data In: ORACLE - Param = 69, Name = PYBYL31, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2678 17:40:29 SQL Data In: ORACLE - Param = 70, Name = PYBYL32, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2679 17:40:29 SQL Data In: ORACLE - Param = 71, Name = PYBYL33, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2680 17:40:29 SQL Data In: ORACLE - Param = 72, Name = PYBYL34, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2681 17:40:29 SQL Data In: ORACLE - Param = 73, Name = PYBYL35, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2682 17:40:29 SQL Data In: ORACLE - Param = 74, Name = PYBYL36, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2683 17:40:29 SQL Data In: ORACLE - Param = 75, Name = PYBYL37, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2684 17:40:29 SQL Data In: ORACLE - Param = 76, Name = PYBYL38, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2685 17:40:29 SQL Data In: ORACLE - Param = 77, Name = PYBYL39, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2686 17:40:29 SQL Data In: ORACLE - Param = 78, Name = PYBYL40, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2687 17:40:29 SQL Data In: ORACLE - Param = 79, Name = PYBYL41, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2688 17:40:29 SQL Data In: ORACLE - Param = 80, Name = PYBYL42, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2689 17:40:29 SQL Data In: ORACLE - Param = 81, Name = PYBYL43, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2690 17:40:29 SQL Data In: ORACLE - Param = 82, Name = PYBYL44, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2691 17:40:29 SQL Data In: ORACLE - Param = 83, Name = PYBYL45, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2692 17:40:29 SQL Data In: ORACLE - Param = 84, Name = PYBYL46, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2693 17:40:29 SQL Data In: ORACLE - Param = 85, Name = PYBYL47, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2694 17:40:29 SQL Data In: ORACLE - Param = 86, Name = PYBYL48, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2695 17:40:29 SQL Data In: ORACLE - Param = 87, Name = PYBYL49, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2696 17:40:29 SQL Data In: ORACLE - Param = 88, Name = PYBYL50, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2697 17:40:29 SQL Data In: ORACLE - Param = 89, Name = PYBYL51, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2698 17:40:29 SQL Data In: ORACLE - Param = 90, Name = PYBYL52, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 97.930000 2699 17:40:29 SQL Data In: ORACLE - Param = 91, Name = PYBYL53, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 80.680000 2700 17:40:29 SQL Data In: ORACLE - Param = 92, Name = PYBYL54, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2701 17:40:29 SQL Data In: ORACLE - Param = 93, Name = PYBYL55, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17.250000 2702 17:40:29 SQL Data In: ORACLE - Param = 94, Name = PYBYL56, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 80.680000 2703 17:40:29 SQL Data In: ORACLE - Param = 95, Name = PYBYL57, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2704 17:40:29 SQL Data In: ORACLE - Param = 96, Name = PYBYL58, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2705 17:40:29 SQL Data In: ORACLE - Param = 97, Name = PYBYL59, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2706 17:40:29 SQL Data In: ORACLE - Param = 98, Name = PYBYL60, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2707 17:40:29 SQL Data In: ORACLE - Param = 99, Name = PYBYL61, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2708 17:40:29 SQL Data In: ORACLE - Param = 100, Name = PYBYL62, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2709 17:40:29 SQL Data In: ORACLE - Param = 101, Name = PYBYL63, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2710 17:40:29 SQL Data In: ORACLE - Param = 102, Name = PYBYL64, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 105.510000 2711 17:40:29 SQL Data In: ORACLE - Param = 103, Name = PYBYL65, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2712 17:40:29 SQL Data In: ORACLE - Param = 104, Name = PYBYL66, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2713 17:40:29 SQL Data In: ORACLE - Param = 105, Name = PYBYL67, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2714 17:40:29 SQL Data In: ORACLE - Param = 106, Name = PYBYL68, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2715 17:40:29 SQL Data In: ORACLE - Param = 107, Name = PYBYL69, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2716 17:40:29 SQL Data In: ORACLE - Param = 108, Name = PYBSM01, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2717 17:40:29 SQL Data In: ORACLE - Param = 109, Name = PYBSM02, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2718 17:40:29 SQL Data In: ORACLE - Param = 110, Name = PYBSM03, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2719 17:40:29 SQL Data In: ORACLE - Param = 111, Name = PYBSM04, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2720 17:40:29 SQL Data In: ORACLE - Param = 112, Name = PYBSM05, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2721 17:40:29 SQL Data In: ORACLE - Param = 113, Name = PYBSM06, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2722 17:40:29 SQL Data In: ORACLE - Param = 114, Name = PYBSM07, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2723 17:40:29 SQL Data In: ORACLE - Param = 115, Name = PYBSM08, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2724 17:40:29 SQL Data In: ORACLE - Param = 116, Name = PYBSM09, Type = fldZSTRING, Precision = 6, Scale = 0, Data = M03900 2725 17:40:29 SQL Data In: ORACLE - Param = 117, Name = PYBSM10, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2726 17:40:29 SQL Data In: ORACLE - Param = 118, Name = PYBSM11, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2727 17:40:29 SQL Data In: ORACLE - Param = 119, Name = PYBSM12, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2728 17:40:29 SQL Data In: ORACLE - Param = 120, Name = PYBSM13, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2729 17:40:29 SQL Data In: ORACLE - Param = 121, Name = PYBSM14, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2730 17:40:29 SQL Data In: ORACLE - Param = 122, Name = PYBSM15, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2731 17:40:29 SQL Data In: ORACLE - Param = 123, Name = PYBSM16, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2732 17:40:29 SQL Data In: ORACLE - Param = 124, Name = PYBSM17, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2733 17:40:29 SQL Data In: ORACLE - Param = 125, Name = PYBSM18, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2734 17:40:29 SQL Data In: ORACLE - Param = 126, Name = PYBSM19, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2735 17:40:29 SQL Data In: ORACLE - Param = 127, Name = PYBSM20, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2736 17:40:29 SQL Data In: ORACLE - Param = 128, Name = PYBSM21, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2737 17:40:29 SQL Data In: ORACLE - Param = 129, Name = PYBSM22, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2738 17:40:29 SQL Data In: ORACLE - Param = 130, Name = PYBSM23, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2739 17:40:29 SQL Data In: ORACLE - Param = 131, Name = PYBSM24, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2740 17:40:29 SQL Data In: ORACLE - Param = 132, Name = PYBSM25, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2741 17:40:29 SQL Data In: ORACLE - Param = 133, Name = PYBSM26, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2742 17:40:29 SQL Data In: ORACLE - Param = 134, Name = PYBSM27, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2743 17:40:29 SQL Data In: ORACLE - Param = 135, Name = PYBSM28, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2744 17:40:29 SQL Data In: ORACLE - Param = 136, Name = PYBSM29, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2745 17:40:29 SQL Data In: ORACLE - Param = 137, Name = Psfyjs0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2746 17:40:29 SQL Data In: ORACLE - Param = 138, Name = Pybjkid, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419758 2747 17:40:29 SQL Data In: ORACLE - Param = 139, Name = Pmxlsh0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 16337724247181542567 2748 17:40:29 SQL Data In: ORACLE - Param = 140, Name = Pghid00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8516590 2749 17:40:29 SQL Data In: ORACLE - Param = 141, Name = Pghh000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2750 17:40:29 SQL Execute: ORACLE - BEGIN "SP_SF_YBFYJS_REPLY" (PID0000 => :PID0000,PJZDH00 => :PJZDH00,PBRID00 => :PBRID00,PCFMXS0 => :PCFMXS0,PYBZHYE => :PYBZHYE,PYBDJH0 => :PYBDJH0,PBCBXF0 => :PBCBXF0,PJJZFE0 => :PJJZFE0,PZHZFE0 => :PZHZFE0,PDBZHZF => :PDBZHZF,PDBJJZF => :PDBJJZF,PSYBXZF => :PSYBXZF,PBJJJZF => :PBJJJZF,PSBZFE0 => :PSBZFE0,PBJZFE0 => :PBJZFE0,PGWYBZ0 => :PGWYBZ0,PDBGRZF => :PDBGRZF,PGRZFE0 => :PGRZFE0,PBCKBCS => :PBCKBCS,PFYBFY0 => :PFYBFY0,PYLZFJE => :PYLZFJE,PCFDXJE => :PCFDXJE,PTSBZBH => :PTSBZBH,PYBSFRQ => :PYBSFRQ,PYBSFSJ => :PYBSFSJ,PCXBZ00 => :PCXBZ00,PCXJZDH => :PCXJZDH,PTMLJ00 => :PTMLJ00,PYBGHH0 => :PYBGHH0,PZYYBJK => :PZYYBJK,PBXLB00 => :PBXLB00,PMXZJE0 => :PMXZJE0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PYBYL01 => :PYBYL01,PYBYL02 => :PYBYL02,PYBYL03 => :PYBYL03,PYBYL04 => :PYBYL04,PYBYL05 => :PYBYL05,PYBYL06 => :PYBYL06,PYBYL07 => :PYBYL07,PYBYL08 => :PYBYL08,PYBYL09 => :PYBYL09,PYBYL10 => :PYBYL10,PYBYL11 => :PYBYL11,PYBYL12 => :PYBYL12,PYBYL13 => :PYBYL13,PYBYL14 => :PYBYL14,PYBYL15 => :PYBYL15,PYBYL16 => :PYBYL16,PYBYL17 => :PYBYL17,PYBYL18 => :PYBYL18,PYBYL19 => :PYBYL19,PYBYL20 => :PYBYL20,PYBYL21 => :PYBYL21,PYBYL22 => :PYBYL22,PYBYL23 => :PYBYL23,PYBYL24 => :PYBYL24,PYBYL25 => :PYBYL25,PYBYL26 => :PYBYL26,PYBYL27 => :PYBYL27,PYBYL28 => :PYBYL28,PYBYL29 => :PYBYL29,PYBYL30 => :PYBYL30,PYBYL31 => :PYBYL31,PYBYL32 => :PYBYL32,PYBYL33 => :PYBYL33,PYBYL34 => :PYBYL34,PYBYL35 => :PYBYL35,PYBYL36 => :PYBYL36,PYBYL37 => :PYBYL37,PYBYL38 => :PYBYL38,PYBYL39 => :PYBYL39,PYBYL40 => :PYBYL40,PYBYL41 => :PYBYL41,PYBYL42 => :PYBYL42,PYBYL43 => :PYBYL43,PYBYL44 => :PYBYL44,PYBYL45 => :PYBYL45,PYBYL46 => :PYBYL46,PYBYL47 => :PYBYL47,PYBYL48 => :PYBYL48,PYBYL49 => :PYBYL49,PYBYL50 => :PYBYL50,PYBYL51 => :PYBYL51,PYBYL52 => :PYBYL52,PYBYL53 => :PYBYL53,PYBYL54 => :PYBYL54,PYBYL55 => :PYBYL55,PYBYL56 => :PYBYL56,PYBYL57 => :PYBYL57,PYBYL58 => :PYBYL58,PYBYL59 => :PYBYL59,PYBYL60 => :PYBYL60,PYBYL61 => :PYBYL61,PYBYL62 => :PYBYL62,PYBYL63 => :PYBYL63,PYBYL64 => :PYBYL64,PYBYL65 => :PYBYL65,PYBYL66 => :PYBYL66,PYBYL67 => :PYBYL67,PYBYL68 => :PYBYL68,PYBYL69 => :PYBYL69,PYBSM01 => :PYBSM01,PYBSM02 => :PYBSM02,PYBSM03 => :PYBSM03,PYBSM04 => :PYBSM04,PYBSM05 => :PYBSM05,PYBSM06 => :PYBSM06,PYBSM07 => :PYBSM07,PYBSM08 => :PYBSM08,PYBSM09 => :PYBSM09,PYBSM10 => :PYBSM10,PYBSM11 => :PYBSM11,PYBSM12 => :PYBSM12,PYBSM13 => :PYBSM13,PYBSM14 => :PYBSM14,PYBSM15 => :PYBSM15,PYBSM16 => :PYBSM16,PYBSM17 => :PYBSM17,PYBSM18 => :PYBSM18,PYBSM19 => :PYBSM19,PYBSM20 => :PYBSM20,PYBSM21 => :PYBSM21,PYBSM22 => :PYBSM22,PYBSM23 => :PYBSM23,PYBSM24 => :PYBSM24,PYBSM25 => :PYBSM25,PYBSM26 => :PYBSM26,PYBSM27 => :PYBSM27,PYBSM28 => :PYBSM28,PYBSM29 => :PYBSM29,Psfyjs0 => :Psfyjs0,Pybjkid => :Pybjkid,Pmxlsh0 => :Pmxlsh0,Pghid00 => :Pghid00,Pghh000 => :Pghh000); END; 2751 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933589.000000 2752 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933589.000000 2753 17:40:29 SQL Execute: ORACLE - select sum(jmje00) jmje00 from ( select nvl(sum(-a.hjje00),0) jmje00 from SF_FYMX00_TEMP00 a where a.jzdh00 = ? and a.xmbh00 >9999999900 and a.xmbh00<9999999990 union all select nvl(sum(a.jmje00),0) jmje00 from SF_FYMX00_TEMP00 a where a.jzdh00 = ? and a.jmbz00 in ('3','4')) 2754 17:40:29 SQL Data In: ORACLE - Param = 1, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933589.000000 2755 17:40:29 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2756 17:40:29 SQL Data In: ORACLE - Param = 3, Name = PPJH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2757 17:40:29 SQL Data In: ORACLE - Param = 4, Name = PCZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2758 17:40:29 SQL Data In: ORACLE - Param = 5, Name = PCZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:40:22 2759 17:40:29 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2760 17:40:29 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2761 17:40:29 SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 2762 17:40:29 SQL Data In: ORACLE - Param = 9, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2763 17:40:29 SQL Data In: ORACLE - Param = 10, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2764 17:40:29 SQL Data In: ORACLE - Param = 11, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2765 17:40:29 SQL Execute: ORACLE - BEGIN "SP_SF_YBFYJS_INSERT" (PJZDH00 => :PJZDH00,PBRID00 => :PBRID00,PPJH000 => :PPJH000,PCZRQ00 => :PCZRQ00,PCZSJ00 => :PCZSJ00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 2766 17:40:29 SQL Execute: ORACLE - Select SQ_YF_MZCF00_KFPC00.NextVal Val from Dual 2767 17:40:29 SQL Execute: ORACLE - Select SQ_SF_BRJFB0_DJH000.NextVal Val from Dual 2768 17:40:29 SQL Data In: ORACLE - Param = 1, Name = AS_CFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6194619 2769 17:40:29 SQL Data In: ORACLE - Param = 2, Name = AD_DJH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 25390144.000000 2770 17:40:29 SQL Data In: ORACLE - Param = 3, Name = AD_SFCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2771 17:40:29 SQL Data In: ORACLE - Param = 4, Name = AD_PYCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2772 17:40:29 SQL Data In: ORACLE - Param = 5, Name = AD_FYCKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2773 17:40:29 SQL Data In: ORACLE - Param = 6, Name = AS_SFQZF0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 2774 17:40:29 SQL Data In: ORACLE - Param = 7, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2775 17:40:29 SQL Data In: ORACLE - Param = 8, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2776 17:40:29 SQL Data In: ORACLE - Param = 9, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2777 17:40:29 SQL Data In: ORACLE - Param = 10, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2778 17:40:29 SQL Data In: ORACLE - Param = 11, Name = ad_KFPC00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 790385.000000 2779 17:40:29 SQL Execute: ORACLE - BEGIN "SP_SF_YFCF00" (AS_CFLSH0 => :AS_CFLSH0,AD_DJH000 => :AD_DJH000,AD_SFCKBH => :AD_SFCKBH,AD_PYCKBH => :AD_PYCKBH,AD_FYCKBH => :AD_FYCKBH,AS_SFQZF0 => :AS_SFQZF0,AD_CZY000 => :AD_CZY000,AD_CZYKS0 => :AD_CZYKS0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,ad_KFPC00 => :ad_KFPC00); END; 2780 17:40:29 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6194619 2781 17:40:29 SQL Data In: ORACLE - Param = 2, Name = PDJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2782 17:40:29 SQL Data In: ORACLE - Param = 3, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933589.000000 2783 17:40:29 SQL Data In: ORACLE - Param = 4, Name = PYBDJH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1520207 2784 17:40:29 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2785 17:40:29 SQL Data In: ORACLE - Param = 6, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2786 17:40:29 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 2787 17:40:29 SQL Data In: ORACLE - Param = 8, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2788 17:40:29 SQL Data In: ORACLE - Param = 9, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2789 17:40:29 SQL Data In: ORACLE - Param = 10, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2790 17:40:29 SQL Execute: ORACLE - BEGIN "SP_SF_FYJS00_JZDH00" (PCFLSH0 => :PCFLSH0,PDJLB00 => :PDJLB00,PJZDH00 => :PJZDH00,PYBDJH0 => :PYBDJH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 2791 17:40:29 SQL Data In: ORACLE - Param = 1, Name = PCFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6194619 2792 17:40:29 SQL Data In: ORACLE - Param = 2, Name = PDJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 2793 17:40:29 SQL Data In: ORACLE - Param = 3, Name = PJZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933589.000000 2794 17:40:29 SQL Data In: ORACLE - Param = 4, Name = PYBDJH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1520207 2795 17:40:29 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2796 17:40:29 SQL Data In: ORACLE - Param = 6, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2797 17:40:29 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 2798 17:40:29 SQL Data In: ORACLE - Param = 8, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2799 17:40:29 SQL Data In: ORACLE - Param = 9, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2800 17:40:29 SQL Data In: ORACLE - Param = 10, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2801 17:40:29 SQL Execute: ORACLE - BEGIN "SP_SF_FYJS00_JZDH00" (PCFLSH0 => :PCFLSH0,PDJLB00 => :PDJLB00,PJZDH00 => :PJZDH00,PYBDJH0 => :PYBDJH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00); END; 2802 17:40:29 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1520207 2803 17:40:29 SQL Data In: ORACLE - Param = 2, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933589.000000 2804 17:40:29 SQL Data In: ORACLE - Param = 3, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2805 17:40:29 SQL Data In: ORACLE - Param = 4, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2806 17:40:29 SQL Data In: ORACLE - Param = 5, Name = AS_ICKH00, Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBK51787670 2807 17:40:29 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2808 17:40:29 SQL Data In: ORACLE - Param = 7, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 2809 17:40:29 SQL Data In: ORACLE - Param = 8, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 王卫华 2810 17:40:29 SQL Data In: ORACLE - Param = 9, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 2811 17:40:29 SQL Data In: ORACLE - Param = 10, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 2812 17:40:29 SQL Data In: ORACLE - Param = 11, Name = AD_BRZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 97.930000 2813 17:40:29 SQL Data In: ORACLE - Param = 12, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2814 17:40:29 SQL Data In: ORACLE - Param = 13, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2815 17:40:29 SQL Data In: ORACLE - Param = 14, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 97.930000 2816 17:40:29 SQL Data In: ORACLE - Param = 15, Name = AD_JMJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2817 17:40:29 SQL Data In: ORACLE - Param = 16, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 6 2818 17:40:29 SQL Data In: ORACLE - Param = 17, Name = AS_YBJZRQ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 2819 17:40:29 SQL Data In: ORACLE - Param = 18, Name = AS_YBJZSJ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 2820 17:40:29 SQL Data In: ORACLE - Param = 19, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 97.930000 2821 17:40:29 SQL Data In: ORACLE - Param = 20, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2822 17:40:29 SQL Data In: ORACLE - Param = 21, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 王勇 2823 17:40:29 SQL Data In: ORACLE - Param = 22, Name = AD_JZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2824 17:40:29 SQL Data In: ORACLE - Param = 23, Name = AS_JMYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2825 17:40:29 SQL Data In: ORACLE - Param = 24, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2826 17:40:29 SQL Data In: ORACLE - Param = 25, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2827 17:40:29 SQL Data In: ORACLE - Param = 26, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 2828 17:40:29 SQL Data In: ORACLE - Param = 27, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 6, Scale = 0, Data = M03900 2829 17:40:29 SQL Data In: ORACLE - Param = 28, Name = AS_SFDYFP, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 2830 17:40:29 SQL Data In: ORACLE - Param = 29, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2831 17:40:29 SQL Data In: ORACLE - Param = 30, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2832 17:40:29 SQL Data In: ORACLE - Param = 31, Name = AS_SFSCJS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 2833 17:40:29 SQL Data In: ORACLE - Param = 32, Name = AS_BYCS00, Type = fldZSTRING, Precision = 19, Scale = 0, Data = 01 2834 17:40:29 SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_JS0000" (AS_YBDJH0 => :AS_YBDJH0,AD_JZDH00 => :AD_JZDH00,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_ICKH00 => :AS_ICKH00,AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AD_BRFB00 => :AD_BRFB00,AD_BRZJE0 => :AD_BRZJE0,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AD_HJJE00 => :AD_HJJE00,AD_JMJE00 => :AD_JMJE00,AS_ZPZH00 => :AS_ZPZH00,AS_YBJZRQ => :AS_YBJZRQ,AS_YBJZSJ => :AS_YBJZSJ,AD_ZFJE00 => :AD_ZFJE00,AD_JZY000 => :AD_JZY000,AS_JZYXM0 => :AS_JZYXM0,AD_JZYKS0 => :AD_JZYKS0,AS_JMYY00 => :AS_JMYY00,AS_YJJXH0 => :AS_YJJXH0,AS_CZBZ00 => :AS_CZBZ00,AS_SFYB00 => :AS_SFYB00,AS_TSBZBH => :AS_TSBZBH,AS_SFDYFP => :AS_SFDYFP,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_SFSCJS => :AS_SFSCJS,AS_BYCS00 => :AS_BYCS00); END; 2835 17:40:29 SQL Execute: ORACLE - commit 2836 17:40:29 SQL Data In: ORACLE - Rows affected = 0 2837 17:40:29 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保新接口参数设置' and BH0000 = 'YBJYDZ_MZ' 2838 17:40:29 SQL Execute: ORACLE - select trim(MC0000) as VALUE0,ZDMC00 as BZ0000,sysdate as DTRQ00 from BM_TYZD00 where ZDMC00='医保新接口参数设置' and BH0000='YBXJKSQM' 2839 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 医保新接口参数设置 2840 17:40:29 SQL Execute: ORACLE - select trim(BH0000)BH0000,trim(MC0000)MC0000 from BM_TYZD00 where ZDMC00=? order by XSXH00 2841 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2842 17:40:29 SQL Execute: ORACLE - Select * from bm_ygbm00 where YGBH00=? 2843 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2844 17:40:29 SQL Execute: ORACLE - select B.YBYHBM,B.YBYHMM from BM_BMBM00 A,XT_YYXX00 B where A.YYID00=B.YYID00 and A.BMBH00=? 2845 17:40:29 SQL Execute: ORACLE - select SF_SF_GETYYID00() as YYID00 from dual 2846 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBDZ_0000 2847 17:40:29 SQL Execute: ORACLE - Select * from BM_TYCJBM where CJBM00=? 2848 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2849 17:40:29 SQL Execute: ORACLE - Select a.YBKH00,a.YBID00,a.BRXM00,a.BRXB00,a.BRZJBH,a.FBBH00,a.YBKSBM from bm_brxxb0 a where a.brid00=? 2850 17:40:29 SQL Execute: ORACLE - select SQ_BM_ZFPTCS_NBID00.Nextval from dual 2851 17:40:29 SQL Execute: ORACLE - insert into BM_ZFPTCS(DDLSH0,MKLXMC,JKQQCS)values ('YBJK202110091740284681623927','新医保接口','Y29766229335892933589门诊结算交易对账010') 2852 17:40:29 SQL Data In: ORACLE - Rows affected = 1 2853 17:40:29 SQL Data In: ORACLE - Param = 1, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBDZ_0000 2854 17:40:29 SQL Data In: ORACLE - Param = 2, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2855 17:40:29 SQL Data In: ORACLE - Param = 3, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2856 17:40:29 SQL Data In: ORACLE - Param = 4, Name = PGHH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2857 17:40:29 SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2858 17:40:29 SQL Data In: ORACLE - Param = 6, Name = PCZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 王勇 2859 17:40:29 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2860 17:40:29 SQL Data In: ORACLE - Param = 8, Name = PQQCSID, Type = fldZSTRING, Precision = 28, Scale = 0, Data = YBJK202110091740284681623927 2861 17:40:29 SQL Data In: ORACLE - Param = 9, Name = PINCS00, Type = fldZSTRING, Precision = 227, Scale = 0, Data = Y29766229335892933589门诊结算交易对账010 2862 17:40:29 SQL Data In: ORACLE - Param = 10, Name = POTHER0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 门诊结算交易对账 2863 17:40:29 SQL Data In: ORACLE - Param = 11, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 2864 17:40:29 SQL Data In: ORACLE - Param = 12, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2865 17:40:29 SQL Data In: ORACLE - Param = 13, Name = PYBJKID, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2866 17:40:29 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2867 17:40:29 SQL Execute: ORACLE - BEGIN "SP_SF_NEWYBJK_YBJKRZ" (PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PGHID00 => :PGHID00,PGHH000 => :PGHH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PYBJKID => :PYBJKID,PERRMSG => :PERRMSG); END; 2868 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 2869 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419759 2870 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = bke284 2871 17:40:29 SQL Execute: ORACLE - update SF_YBJKMX set JKFSZ0=? where YBJKID=? and ZDBM00=? 2872 17:40:29 SQL Data In: ORACLE - Rows affected = 0 2873 17:40:29 SQL Execute: ORACLE - COMMIT 2874 17:40:29 SQL Data In: ORACLE - Rows affected = 0 2875 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419759 2876 17:40:29 SQL Execute: ORACLE - select count(distinct(JDBM00)) as Num from SF_YBJKMX where YBJKID=? and ZJDBM0='data' 2877 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419759 2878 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main 2879 17:40:29 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 2880 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419759 2881 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 2882 17:40:29 SQL Execute: ORACLE - select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('1','3') order by JKMXID 2883 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419759 2884 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = main 2885 17:40:29 SQL Execute: ORACLE - Select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('2','3') order by JKMXID 2886 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2887 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419759 2888 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = flag 2889 17:40:29 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2890 17:40:29 SQL Data In: ORACLE - Rows affected = 1 2891 17:40:29 SQL Execute: ORACLE - COMMIT 2892 17:40:29 SQL Data In: ORACLE - Rows affected = 0 2893 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 2894 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419759 2895 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = cause 2896 17:40:29 SQL Execute: ORACLE - update SF_YBJKMX set JKFHZ0=? where YBJKID=? and ZDBM00=? 2897 17:40:29 SQL Data In: ORACLE - Rows affected = 1 2898 17:40:29 SQL Execute: ORACLE - COMMIT 2899 17:40:29 SQL Data In: ORACLE - Rows affected = 0 2900 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419759 2901 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = data 2902 17:40:29 SQL Execute: ORACLE - Select * from SF_YBJKMX where YBJKID=? and JDBM00=? and FSLXBZ in ('2','3') order by JKMXID 2903 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 2904 17:40:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 2905 17:40:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2906 17:40:29 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 操作成功 2907 17:40:29 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 185, Scale = 0, Data = {"usr":"350000010835000000001","pwd":"yblw888888","funid":"yb04.07.03.05","data":{"aka078":"10","akc190":"4985839","aae072":"1520207","bke298":"419758","bka555":"01","aab301":"359900"}} 2908 17:40:29 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 54, Scale = 0, Data = {"traceid":"","flag":"1","data":{},"cause":"操作成功"} 2909 17:40:29 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419759 2910 17:40:29 SQL Execute: ORACLE - update SF_YBJKRZ set DLLZT0=?,DLLERR=?,FLAG=?,CAUSE=?,JKQQCS=?,JKFHCS=? where YBJKID=? 2911 17:40:29 SQL Data In: ORACLE - Rows affected = 1 2912 17:40:29 SQL Execute: ORACLE - COMMIT 2913 17:40:29 SQL Data In: ORACLE - Rows affected = 0 2914 17:40:29 SQL Data In: ORACLE - Param = 1, Name = PYBJKID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 419759 2915 17:40:29 SQL Data In: ORACLE - Param = 2, Name = PJKCJBM, Type = fldZSTRING, Precision = 14, Scale = 0, Data = YBJK_YBDZ_0000 2916 17:40:29 SQL Data In: ORACLE - Param = 3, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2917 17:40:29 SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 2918 17:40:29 SQL Data In: ORACLE - Param = 5, Name = PGHH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 2919 17:40:29 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2920 17:40:29 SQL Data In: ORACLE - Param = 7, Name = PCZYXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 王勇 2921 17:40:29 SQL Data In: ORACLE - Param = 8, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2922 17:40:29 SQL Data In: ORACLE - Param = 9, Name = PQQCSID, Type = fldZSTRING, Precision = 28, Scale = 0, Data = YBJK202110091740284681623927 2923 17:40:29 SQL Data In: ORACLE - Param = 10, Name = PINCS00, Type = fldZSTRING, Precision = 227, Scale = 0, Data = Y29766229335892933589门诊结算交易对账010 2924 17:40:29 SQL Data In: ORACLE - Param = 11, Name = POTHER0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 门诊结算交易对账 2925 17:40:29 SQL Data In: ORACLE - Param = 12, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 2926 17:40:29 SQL Data In: ORACLE - Param = 13, Name = PZXZT00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2927 17:40:29 SQL Data In: ORACLE - Param = 14, Name = PERRMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2928 17:40:29 SQL Execute: ORACLE - BEGIN "SP_SF_NEWYBJK_YBJKQR" (PYBJKID => :PYBJKID,PJKCJBM => :PJKCJBM,PBRID00 => :PBRID00,PGHID00 => :PGHID00,PGHH000 => :PGHH000,PCZY000 => :PCZY000,PCZYXM0 => :PCZYXM0,PCZYKS0 => :PCZYKS0,PQQCSID => :PQQCSID,PINCS00 => :PINCS00,POTHER0 => :POTHER0,PCOMMIT => :PCOMMIT,PZXZT00 => :PZXZT00,PERRMSG => :PERRMSG); END; 2929 17:40:29 SQL Execute: ORACLE - COMMIT 2930 17:40:29 SQL Data In: ORACLE - Rows affected = 0 2931 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2932 17:40:29 SQL Execute: ORACLE - select SF_SF_GETKYJE(a.BRID00,1,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,a.* from sf_brzhxx a where jflbid = 1 and brid00=? 2933 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2934 17:40:29 SQL Execute: ORACLE - select SF_SF_GETKYJE(a.BRID00,1,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,a.* from sf_brzhxx a where jflbid = 1 and brid00=? 2935 17:40:29 SQL Execute: ORACLE - select SF_XT_GETTDBRTSXX('0',297662.00,0.00,'FYJS',2.00,'1') as FHTSXX from dual 2936 17:40:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2933589.000000 2937 17:40:29 SQL Execute: ORACLE - select a.PJH000,b.PJXH00 from sf_jzb000 a,sf_pjsyqk b where a.jzdh00=? and a.pjh000=b.pjh000 and brzje0 > 0 2938 17:40:29 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '第三方电子发票平台接口' and BH0000 = 'printDZFP_MZ' 2939 17:40:33 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8973329 2940 17:40:33 SQL Execute: ORACLE - select * from VW_SF_ZZFPXX where PJH000 = ? 2941 17:40:33 SQL Execute: ORACLE - select 1239 as UserId,'100050' as UserCode,'王勇' as UserName,493 as UserLogDepId,'门诊收费处' as UserLogDepName, '4' as UserLogSysCode,'门诊收费管理系统' as UserLogSysName,'220035' as HospitalCode,'福建省老年医院' as HospitalName, '220035' as UserLogDepYYID,'福建省老年医院' as UserLogDepYYMC from dual 2942 17:40:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2943 17:40:34 SQL Execute: ORACLE - select SF_SF_GETKYJE(a.BRID00,1,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,a.* from sf_brzhxx a where jflbid = 1 and brid00=? 2944 17:40:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 2945 17:40:34 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBK51787670 2946 17:40:34 SQL Execute: ORACLE - select a.* from VW_SF_BRZHXX a where a.SFDJ00<>'2' and a.JFLBID = ? and a.ICKH00 = ? 2947 17:40:34 SQL Execute: ORACLE - select SF_SF_GETBRDGZFYBZ(297662,493,0) as FYGZBZ from dual 2948 17:40:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2949 17:40:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 2950 17:40:35 SQL Execute: ORACLE - select E.CSLX00,A.KHRQ00,A.XJYE00,A.ZZYE00,A.YXQFJE,A.TYJE00,SF_SF_GETKYJE(A.BRID00,1,1,1) as KYJE00,(A.ZYE000-a.TYJE00) as ZHZYE0,B.JFLBMC,D.FBMC00,e.YBMC00, C.BRCSRQ,C.FBBH00,C.BRZJBH,C.BRBLH0,C.BRXM00,C.BRXB00,C.YBKH00,C.YBID00,C.YBLB00,C.YBBRLB,C.BRZTQK from SF_BRZHXX A,BM_BRJFLB B,BM_BRXXB0 C,bm_brfbb0 D,ic_ybbrlb E where A.JFLBID = B.JFLBID and C.FBBH00 = D.FBBH00 and C.fbbh00=E.fbbh00 and C.yblb00=E.yblb00 and A.BRID00 = C.BRID00 and A.SFDJ00 <> '2' and A.BRID00 = ? and A.JFLBID = ? 2951 17:40:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2952 17:40:35 SQL Execute: ORACLE - select TBLBMC from VW_BM_BRXXB2 where BRID00 =? 2953 17:40:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2954 17:40:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2955 17:40:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2956 17:40:35 SQL Execute: ORACLE - select CFLSH0 from YF_MZCF00 where BRID00=? and CFZT00 = '0' and SRRQ00>= ? and SRRQ00<= ? 2957 17:40:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2958 17:40:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 2959 17:40:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2960 17:40:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2961 17:40:35 SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8000000001.000000 2962 17:40:35 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2963 17:40:35 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2964 17:40:35 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2965 17:40:35 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2966 17:40:35 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2967 17:40:35 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20211009 2968 17:40:35 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 2969 17:40:35 SQL Execute: ORACLE - select * from ( select a.GHH000,a.FPXMMC,a.XMMC00,a.XMDJ00,a.XMDW00,a.XMSL00,a.HJJE00,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.KDKSMC,a.KDYSXM,a.DJH000,a.TSBZBH,a.TSBZMC,a.ZLXMJC, a.MZFPID,a.JZBZ00,a.JZJE00,a.GFJE00,to_char(a.YJDJH0) as YJDJH0,a.SFLB00,a.MXID00,a.CXBZ00,a.OMXID0,a.CFDGS0,a.ZXKSMC, a.CZRQ00,a.JZZTMC,a.TCNWJC,nvl(a.TCID00,0) as TCID00,a.TCXMMC from VW_SF_WJSFYMX a where a.BRID00 = ? and a.JFLBID = ? and a.CZRQ00>= ? and a.CZRQ00<= ? and a.XMBH00+0 <> ? union all select a.GHH000,a.FPXMMC,a.SFXMMC,a.XMDJ00,a.XMDW00,a.XMSL00,a.AMOUNT,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.BMMC00 KDKSMC,a.KDYSXM,0 DJH000,a.TSBZBH,a.TSBZMC,a.ZLXMJC, a.FPXMID,a.JZBZ00,a.JZJE00,a.GFJE00,to_char(A.YJDJH0),a.JSXM00 SFLB00,a.ID0000 MXID00,'Z',0,a.CFDGS0,a.YJKSMC, a.KDRQ00,a.JZZTMC,'' as TCNWJC,nvl(a.TCID00,0) as TCID00,a.TCXMMC from VW_SF_YJYWMX a where a.CXDJH0 is null and A.BRID00 = ? and a.KDRQ00>= ? and a.KDRQ00<= ? union all select a.GHH000,a.FPXMMC,a.YPMC00,a.LSDJ00,a.CFDW00,a.YPZSL0,a.AMOUNT,a.ZFBL00,a.ZFJE00,a.JJSJ00, a.KDKSMC,a.YSXM00,0 DJH000,a.TSBZBH,a.TSBZMC,FPXMMC ZLXMJC, a.FPXMID,a.JZBZ00,a.JZJE00,a.GFJE00,a.CFLSH0,a.SFLB00,CFID00 MXID00,'Z',0,a.CFDGS0,a.BMMC00, a.SRRQ00,a.JZZTMC,'' as TCNWJC,0 as TCID00,null as TCXMMC from VW_SF_CFMX00 a where a.BCCFH0 is null and a.THBZ00='0' and a.BRID00 = ? and a.SRRQ00>= ? and a.SRRQ00<= ? and a.SRRQ00>= to_char(sysdate-?,'YYYYMMDD') ) order by GHH000,JZBZ00,MZFPID,CFDGS0,YJDJH0,MXID00,ZLXMJC 2970 17:40:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 2971 17:40:35 SQL Execute: ORACLE - select trim(mc0000) mc0000 from VW_SF_TSBZB0 where ybzxlb = ? 2972 17:40:35 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 297662.000000 2973 17:40:35 SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 2974 17:40:35 SQL Data In: ORACLE - Param = 3, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 2975 17:40:35 SQL Data In: ORACLE - Param = 4, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 2976 17:40:35 SQL Data In: ORACLE - Param = 5, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2977 17:40:35 SQL Data In: ORACLE - Param = 6, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2978 17:40:35 SQL Data In: ORACLE - Param = 7, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 2979 17:40:35 SQL Data In: ORACLE - Param = 8, Name = PPHZXH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 2980 17:40:35 SQL Execute: ORACLE - BEGIN "SP_SST_SFCFQH_YKT" (PBRID00 => :PBRID00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PPHZXH0 => :PPHZXH0); END; 2981 17:40:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 297662 2982 17:40:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2002995 2983 17:40:36 SQL Execute: ORACLE - select CFLSH0 from yf_cfdl00 where BRID00=? and PHZXH0=? 2984 17:40:45 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE upper(SJKYH0) = 'SD_HOSPITAL' 2985 17:40:45 SQL Execute: ORACLE - select XTBB00 from XT_YYXT00 where XTDM00='4' 2986 17:40:45 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 2987 17:40:45 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 = '' 2988 17:40:45 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '通用平台病人主索引接口设置' and BH0000 = 'OPEN_MZ' 2989 17:40:45 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '取药队列字典' and BH0000 = 'DSFBYJK_MZ' 2990 17:40:45 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'PACS接口字典' and BH0000 = 'PACSYYJK_Open' 2991 17:40:45 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '第三方电子发票平台接口' and BH0000 = 'printDZFP_MZ' 2992 17:40:45 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,1239,'王勇','192.168.202.168','74-27-EA-3A-F7-34','4','ACT_MZSF_YW_BSDZFPZHCZ','12411182') 2993 17:40:45 SQL Data In: ORACLE - Rows affected = 1 2994 17:40:45 SQL Execute: ORACLE - Commit 2995 17:40:45 SQL Data In: ORACLE - Rows affected = 0 2996 17:40:46 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS' 2997 17:40:46 SQL Execute: ORACLE - Select SYSDATE from Dual 2998 17:40:46 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') 2999 17:40:46 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') 3000 17:40:46 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') 3001 17:40:49 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBK53919999' and ICKNBH = 'FZYBK53919999' 3002 17:40:49 SQL Execute: ORACLE - select BRID00 from IC_YHXX00 where ZT0000='1' and ICKH00 = 'FZYBK53919999' 3003 17:40:49 SQL Execute: ORACLE - select * from VW_BM_BRXXB3 where BRID00 = 4554627.00 3004 17:40:49 SQL Execute: ORACLE - select * from VW_SF_JSXX00 where BRID00 = 4554627.00 and JZRQ00 between '20210909' and '20211009' order by JZDH00 desc 3005 17:40:49 SQL Execute: ORACLE - select * from VW_SF_WBFPXX where JZDH00 = 2933561.00 order by WBID00 3006 17:40:52 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '第三方电子发票平台接口' and BH0000 = 'DZFPKJSFYZCZY' 3007 17:40:52 SQL Execute: ORACLE - select * from VW_SF_PJSYQK where PJH000=8973305.00 3008 17:41:21 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS' 3009 17:41:21 SQL Execute: ORACLE - Select SYSDATE from Dual 3010 17:41:21 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') 3011 17:41:22 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') 3012 17:41:22 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') 3013 17:41:25 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBK53919999' and ICKNBH = 'FZYBK53919999' 3014 17:41:25 SQL Execute: ORACLE - select BRID00 from IC_YHXX00 where ZT0000='1' and ICKH00 = 'FZYBK53919999' 3015 17:41:25 SQL Execute: ORACLE - select * from VW_BM_BRXXB3 where BRID00 = 4554627.00 3016 17:41:25 SQL Execute: ORACLE - select * from VW_SF_JSXX00 where BRID00 = 4554627.00 and JZRQ00 between '20210909' and '20211009' order by JZDH00 desc 3017 17:41:25 SQL Execute: ORACLE - select * from VW_SF_WBFPXX where JZDH00 = 2933561.00 order by WBID00 3018 17:41:28 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '第三方电子发票平台接口' and BH0000 = 'DZFPKJSFYZCZY' 3019 17:41:28 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '第三方电子发票平台接口' and BH0000 = 'printDZFP_MZ' 3020 17:41:35 SQL Execute: ORACLE - select * from VW_SF_JSXX00 where BRID00 = 4554627.00 and JZRQ00 between '20210909' and '20211009' order by JZDH00 desc 3021 17:41:35 SQL Execute: ORACLE - select * from VW_SF_WBFPXX where JZDH00 = 2933561.00 order by WBID00 3022 17:41:35 SQL Execute: ORACLE - select * from VW_SF_WBFPXX where JZDH00 = 2933561.00 order by WBID00 3023 17:41:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8973305 3024 17:41:50 SQL Execute: ORACLE - select * from VW_SF_ZZFPXX where PJH000 = ? 3025 17:41:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8973305 3026 17:41:50 SQL Execute: ORACLE - select * from VW_SF_PJSYMX_NEW where PJH000= ? and XMJE00<>0 order by XMBH00 3027 17:41:50 SQL Execute: ORACLE - select 1239 as UserId,'100050' as UserCode,'王勇' as UserName,493 as UserLogDepId,'门诊收费处' as UserLogDepName, '4' as UserLogSysCode,'门诊收费管理系统' as UserLogSysName,'220035' as HospitalCode,'福建省老年医院' as HospitalName, '220035' as UserLogDepYYID,'福建省老年医院' as UserLogDepYYMC from dual 3028 17:42:24 SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1239.000000 3029 17:42:24 SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 493.000000 3030 17:42:24 SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17160323.000000 3031 17:42:24 SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END; 3032 17:42:24 SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 1239 and CZXH00 = 17160323.00)