CREATE OR REPLACE TRIGGER TR_BM_BRXXB0_BEFDEL
 BEFORE 
 DELETE
 ON SD_HOSPITAL.BM_BRXXB0
 REFERENCING OLD AS OLD NEW AS NEW
 FOR EACH ROW 
declare
	E_BNSC00    EXCEPTION;	   
-- MODIFICATION HISTORY
-- Person      Date        Comments
-- 
begin
        RAISE E_BNSC00;
exception
     WHEN E_BNSC00 THEN
	  RAISE_APPLICATION_ERROR(-21917,'病人信息表的信息不能删除,非法操作!'||'!*');
          ROLLBACK;
     WHEN OTHERS THEN
	  RAISE_APPLICATION_ERROR(-21918,substr(nvl(sqlerrm,'出错原因不详'),1,40)||'，请记录此信息并和系统管理员联系！'||'!*');
	  ROLLBACK;
end;

/