Thanks Milan, this is the code for anyone who's interested.

select rdb$dependent_name,rdb$depended_on_name from rdb$dependencies
where rdb$depended_on_type=15
order by rdb$dependent_name,rdb$depended_on_name

It saves a lot of time and then as you suggest, procedures can be
altered as required. I use the customer version of Ibexpert so it
becomes easy.

Alan J Davies
Aldis

On 25/05/2011 16:57, Milan Babuskov wrote:
> Alan J Davies wrote:
> > Hi, is it possible to get a list of UDFs and the various SPs that have a
> > dependency on them, from rdb$.....?
>
> rdb$dependencies
>
> > I do know the udfs in each database, but its a long job to check each
> > one individually.
>
> It is simplest to ALTER all the procedures. Dump database DDL (using
> FlameRobin, for example), copy/paste the ALTER PROCEDURE section and run it.
>
> --
> Milan Babuskov
>
> ==================================
> The easiest way to import XML, CSV
> and textual files into Firebird:
> http://www.guacosoft.com/xmlwizard
> ==================================
>
>
> ------------------------------------------------------------------------
>
> No virus found in this message.
> Checked by AVG - www.avg.com <http://www.avg.com>
> Version: 10.0.1375 / Virus Database: 1509/3658 - Release Date: 05/24/11
>