Hi,

>When I ran the code outside of a stored procedure (Select ...... Into.....)
> >everything goes allright and I get the results I expected. so what I am a
> >doing wrong? How can I make this work in a stored procedure?
>According to the IB 6 Beta documentation(Language Reference volume, page
>175), the output parameters of a stored procedure can be of any type,
>except Blobs and Arrays.

That explains things. Didn't notice that in the docs.

Bert