1234567891011121314151617181920212223242526272829303132 |
- [12:53:18] DB Error Occured. FILE: PRK0010MF.cpp LINE: 1554 FUNC: TPRK0010M::MergePrkPlcePrv
- Title: TPRK0010M::MergePrkPlcePrv
- Class: EOleException
- Error:
- TBR-04008 (23000): Duplicate unique key found during multi insert
- SQL :
- MERGE INTO TB_PRK_PLCE_PRV L
- USING (SELECT
- :p01 AS PRK_PLCE_NMBR,
- :p02 AS VHCTY_AR_SE,
- :p03 AS VHCTY_AR_PRK_CMPRT_CO,
- 0 AS VHCTY_AR_REMNDR_PRK_CMPRT_CO
- FROM DUAL) M
- ON (L.PRK_PLCE_NMBR = M.PRK_PLCE_NMBR)
- WHEN MATCHED THEN
- UPDATE SET
- L.VHCTY_AR_SE = M.VHCTY_AR_SE,
- L.VHCTY_AR_PRK_CMPRT_CO = M.VHCTY_AR_PRK_CMPRT_CO
- WHEN NOT MATCHED THEN
- INSERT (
- PRK_PLCE_NMBR,
- VHCTY_AR_SE,
- VHCTY_AR_PRK_CMPRT_CO,
- VHCTY_AR_REMNDR_PRK_CMPRT_CO )
- VALUES (
- M.PRK_PLCE_NMBR,
- M.VHCTY_AR_SE,
- M.VHCTY_AR_PRK_CMPRT_CO,
- M.VHCTY_AR_REMNDR_PRK_CMPRT_CO )
|