Subject Re: ----X Help with UDFs please. Problem loading again
Author Fabrice Aeschbacher

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


--- 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.
> 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:
> Tel: (+27) (0)21-409 7018
> P.O. Box 6330
> Roggebaai
> 8012
> Cape Town
> South Africa