The FRM-41009: function key not allowed. Press % s for list of valid keys

Sometimes clear_block ('another Block') is removed in the trigger when-clear-block, and an error in the FRM-41009 is reported.

You can use the following method to ignore this error.

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;