Subject Re: [ib-support] Strange Reaction if UDF is missing
Author Andrew Guts
I guess you should comment piece of procedure body containing call to
the function and then alter it.
Hope it will help.

Andrew

Dieter Tremel wrote:

>Hallo ib-support,
>
>I have a Problem with UDF Naming Conflicts in Windows and Linux
>versions of FreeUDFLib.
>In Windows the function Name is F_ADDMONTH in Linux it is F_ADD_MONTH.
>I want to make the names equal, so I try to correct the Linux Database
>on the Windows box. The Database is transported with gbak.
>
>When I want to drop the function it tells me:
>
>drop external function F_add_month;
>
>ISC ERROR MESSAGE:
>unsuccessful metadata update
>cannot delete
>UDF F_ADD_MONTH
>there are 1 dependencies
>
>as I know it is in procedure zyklusposten_nextperiod, i do a
>
>drop procedure zyklusposten_nextperiod;
>
>ISC ERROR MESSAGE:
>invalid request BLR at offset 780
>function F_ADD_MONTH is not defined
>module name or entrypoint could not be found
>
>So I have a egg <-> chicken problem. Can't I solve this on the
>Windows machine without the lib?
>
>Why can I not drop the procedure?
>
>Dieter Tremel
>
>
>