--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> SPs expect constants as input

I - as a user - expect to be able to input whatever I like and the SP
cast my expression into the expected type of parameter.

I guess that SPs are made for users and not the other way around :)

I suspect that the related code is already there, because in the
SELECT instance the casting is done alright.

Besides, this different behaviour (btw SELECT and EXECUTE) surprises
me and as a rule a user should never be surprised :)

Best regards

Peppe Polpo