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'
ORA-00001: unique constraint (SYSADM.PS_ECQUEUEINST) violated
UPDATE ps_ecqueueinst
转载于:https://www.cnblogs.com/GoDevil/archive/2008/12/17/1356413.html