Hi
I have a procedure that uses a udf.
The udf's library does not exist anymore.
I cant drop the udf because the procedure depends on it.
I cant edit the procedure because I get the following error:
unsuccessful metadata update
ERASE RDB$PROCEDURE_PARAMETERS failed invalid request BLR at offset 53
function F_EN is not defined module name or entrypoint could not be found.

This message is confusting because the only BLR is in
RDB$PROCEDURES and that I dont want to edit.

I have made my own dummy procedure and put in under the udf directory, I
then edited RDB$FUNCTION_ARGUMENTS.

How do I manage to edit this procedure and drop the udf.

I created a similar procedure and udf to have something to compare against,
and I used that values in the relevant system table to try to see if I could
get it to work. The tables I looked at is:
RDB$DEPENDENCIES
RDB$FUNCTION_ARGUMENTS
RDB$FUNCTIONS
RDB$PROCEDURE_PARAMETERS
RDB$PROCEDURES

Groete
Gerhardus