Fix ecqueueinstance Error

ORA-00001: unique constraint (SYSADM.PS_ECQUEUEINST) violated

UPDATE ps_ecqueueinst
   SET ecqueueinstance = (SELECT MAX (ecqueueinstance) + 1
                            FROM ps_ecqueue
                           WHERE ectransid = 'VOUCHER-IN')
WHERE ectransid = 'VOUCHER-IN'

转载于:https://www.cnblogs.com/GoDevil/archive/2008/12/17/1356413.html