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@...
WWW: http://www.basix.co.za
Tel: (+27) (0)21-409 7018


P.O. Box 6330
Roggebaai
8012
Cape Town
South Africa