ITS_OP_01.err 1.8 KB

1234567891011121314151617181920212223242526272829303132
  1. [12:53:18] DB Error Occured. FILE: PRK0010MF.cpp LINE: 1554 FUNC: TPRK0010M::MergePrkPlcePrv
  2. Title: TPRK0010M::MergePrkPlcePrv
  3. Class: EOleException
  4. Error:
  5. TBR-04008 (23000): Duplicate unique key found during multi insert
  6. SQL :
  7. MERGE INTO TB_PRK_PLCE_PRV L
  8. USING (SELECT
  9. :p01 AS PRK_PLCE_NMBR,
  10. :p02 AS VHCTY_AR_SE,
  11. :p03 AS VHCTY_AR_PRK_CMPRT_CO,
  12. 0 AS VHCTY_AR_REMNDR_PRK_CMPRT_CO
  13. FROM DUAL) M
  14. ON (L.PRK_PLCE_NMBR = M.PRK_PLCE_NMBR)
  15. WHEN MATCHED THEN
  16. UPDATE SET
  17. L.VHCTY_AR_SE = M.VHCTY_AR_SE,
  18. L.VHCTY_AR_PRK_CMPRT_CO = M.VHCTY_AR_PRK_CMPRT_CO
  19. WHEN NOT MATCHED THEN
  20. INSERT (
  21. PRK_PLCE_NMBR,
  22. VHCTY_AR_SE,
  23. VHCTY_AR_PRK_CMPRT_CO,
  24. VHCTY_AR_REMNDR_PRK_CMPRT_CO )
  25. VALUES (
  26. M.PRK_PLCE_NMBR,
  27. M.VHCTY_AR_SE,
  28. M.VHCTY_AR_PRK_CMPRT_CO,
  29. M.VHCTY_AR_REMNDR_PRK_CMPRT_CO )