Hi, is it possible to get a list of UDFs and the various SPs that have a
dependency on them, from rdb$.....?
I do know the udfs in each database, but its a long job to check each
one individually.
e.g.
UDF Stored Procedure
ABS SP1
ABS SP2
LPAD SP3
....

This has become necessary because I'm testing FB 2.5 on a Windows7
system and have encountered a large number of errors with the fudlib
udfs - they just fail, but not all of them. (work perfectly on FB 2.1
system on next desk) "Error writing data to the Connection" message
displays and connection severed. Reconnecting then works fine.

I don't know if anyone has a simple answer to this problem? Otherwise I
need to identify them easily and redo the SPs with a different UDF. Not
an easy task to ensure that production databases don't have these
problems, so its a delay to get them updated from FB 2.1 to FB 2.5.
The rfunc udfs work perfectly, so have I missed an important piece of
advice? Up to this install, all udfs have always worked as before.
Thanks for any guidance.

--
Alan J Davies
Aldis