电商解锁货位调整单

wbv123

H2
报错：ORA-20001:统一接口平台生成的货位调整单不允许前台作废!
           ORA-06512: at "H2.TR T ADJUST STALL H HUDIT", line 27
           ORA-04088: error during execution of trigger H2.TR T ADJUST STALL H_HUDIT
           查看错误堆栈的程序源?
解决方案：
select * from t_adjust_stall_h  where ADJUSTNO = '230712010158'


update t_adjust_stall_h set notes= 'O2O' where ADJUSTNO = '230710010104'

update t_adjust_stall_h set CHECKBIT2 = 2,status = 2 where ADJUSTNO = '23071001004'

一下是批量修改的代码
update t_adjust_stall_h set CHECKBIT2 = 2,status = 2 where ADJUSTNO = '2401010257';
update t_adjust_stall_h set CHECKBIT2 = 2,status = 2 where ADJUSTNO = '2401010227';
update t_adjust_stall_h set CHECKBIT2 = 2,status = 2 where ADJUSTNO = '23123184';

原理是触发器拿备注做了判断，把备注改了 就能作废了