oracel 屏蔽 触发器异常(100)

  • 主题发起人 主题发起人 cyf4
  • 开始时间 开始时间
C

cyf4

Unregistered / Unconfirmed
GUEST, unregistred user!
请教各位大侠,在点击保存之后,没有添加触发器之前的提示:在位置XXXX零件的供应商不能进行交易。添加触发器之后的提示:Current User: IFSAPPCurrent Database: ERPLevel: InformationalCode: ORA-02055Location: dlgArrival.tblDetailText: 分布式更新操作失效;要求回退 ORA-20110: ConsignmentStockManager.ANOTHEROWNER: 在位置 M212-01的此零件库存属于供应商 (334501). 您不允许进行此交易. ORA-06512: 在"IFSAPP.RECEIVE_PURCHASE_ORDER_API", line 679 ORA-06512: 在"IFSAPP.RECEIVE_PURCHASE_OError Text:IFSAPP.Receive_Purchase_Order_API.Packed_Arrival__( :i_hWndFrame.dlgArrival.lsResult,:i_hWndFrame.dlgArrival.lsArrivalResultKeys,:i_hWndFrame.dlgArrival.lsBarCodesAttr,:i_hWndFrame.dlgArrival.lsPackedMessage,:i_hWndFrame.dlgArrival.sPrintArrival,:i_hWndFrame.dlgArrival.sPrintBarCodes )请问我怎么屏蔽这个异常呢.谢谢.在线等待
 
自动异常lE EXCEPTION;当操作发生时,做以下判断,若出现不正常流程。则when others thenpomsg:='替代的处理';raise le;end;
 
老兄我的触发器如下:请找出问题,谢谢create or replace trigger DYSCM_PONMATBILL1 after insert or update or delete on PURCHASE_ORDER_LINE_tab for each rowdeclare sPersonId varchar2(36); vOrderNum NUMBER(20); vGuid varchar2(36);beginselect dyscm_midjobid.nextval into vOrderNum from dual;vGuid :=sys_guid();if deleting then insert into dyscm_midjob@supp (fid, fSRCTYPE, fMSGTYPE, fMSG, fMSGDATE, fOrderNum, fJSEXFIELD01) values (vGuid,'DYSCM_PONMATBILL1', -1,:old.order_no, sysdate, vOrderNum,'删除');elsif inserting then insert into dyscm_midjob@supp (fid, fSRCTYPE, fMSGTYPE, fMSG, fMSGDATE, fOrderNum, fJSEXFIELD01) values (vGuid,'DYSCM_PONMATBILL1', 1,:new.order_no,sysdate, vOrderNum, '添加');elsif updating then insert into dyscm_midjob@supp (fid, fSRCTYPE, fMSGTYPE, fMSG, fMSGDATE, fOrderNum, fJSEXFIELD01) values (vGuid,'DYSCM_PONMATBILL1',2,:old.order_no,sysdate, vOrderNum, '修改');end if;exception when others then Justep_Exception.insert_exception('采购订单确认从表', sParam, 'DYSCM_PONMATBILL1', sqlerrm, sysdate);end DYSCM_PONMATBILL1;
 
后退
顶部