Hi,

Have you tried to drop the SP(s) actually using the UDF, then re-
DECLARE the UDF and then re-create the SP?

Fabrice

--- In ib-support@y..., Louis van Alphen <lja@b...> wrote:
> I have encountered a problem with using UDFs. We use a UDF in a SP.
Someone
> has dropped the UDF without removing it from the SP that uses it.
When we
> want to reload the UDF with DECLARE FUNCTION, we get error
messages. We
> also cannot compile the SP any more, because it needs the UDF even
if we
> comment out the section where the UDF is called. Why is that?
>
> Can someone tell me how to fix this?
>
>
> Thanks
>
>
>
> L.J. van Alphen
> Director
> Basix Automation
>
> E-mail: lja@b...
> WWW: http://www.basix.co.za
> Tel: (+27) (0)21-409 7018
>
>
> P.O. Box 6330
> Roggebaai
> 8012
> Cape Town
> South Africa