Hi,

> I've this simple store procedure:
>
> ....
> FOR EXECUTE STATEMENT
> 'SELECT
> STRLEN(ANA00CDFS)
> FROM
> ANA00'
> INTO
> :ANA00CDFS
> DO BEGIN
> ...
>
> Firebird (1.5.2 on a debian sarge) goes in error with:
>
> Variable type (position 0) in EXECUTE STATEMENT 'SELECT
> STRLEN(ANA00CDFS) ' INTO does not match return.

Sounds like :ANA00CDFS isn't of the same type as what the UDF
returns.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com