有时候在触发器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);BEGINIF ERR_VAL=41009 THENnull;ELSEMESSAGE(MSG);RAISE FORM_TRIGGER_FAILURE;END IF;END;