有时候在触发器WHEN-CLEAR-BLOCK里头去clear_block('另外一个块'),会报FRM-41009的错误。
可以用下面的方法来忽略这个错误。
Even though you cannot suppress it, you can create an on-error trigger to intercept it and prevent from displaying:
DECLARE
ERR_VAL NUMBER(5) := ERROR_CODE;
MSG VARCHAR2(150)
:= SUBSTR(' '||ERROR_TYPE||'-'||TO_CHAR(ERR_VAL)||': '
||ERROR_TEXT,1,150);
BEGIN
IF ERR_VAL=41009 THEN
null;
ELSE
MESSAGE(MSG);
RAISE FORM_TRIGGER_FAILURE;
END IF;
END;