Re: SQL User Defined Function Not Found

Thanks guys. It turned out that it was the fact that the literals were being passed as varchars instead of chars. To fix this I simply used the suggested method of using the CHAR('L') which solved the problem immediately.

Thanks

Alex

message: 3
date: Mon, 27 Oct 2008 08:43:08 -0400
from: rob@xxxxxxxxx
subject: Re: SQL User Defined Function Not Found

Might be a combination of two things
1 - What Vern says.
2 - I've had an issue where my subprocedure name was mixed case yet my
function was all caps. I renamed my subprocedure to all caps. Existing
programs using that subprocedure will not care, but SQL does.

P pr_GetPlhNamW B EXPORT
EXTERNAL NAME 'DEVAW/CDV0110(PR_GETPLHNAMW)'

Rob Berendt