> After changing "STATE" to "STATE1", procedure works good.
>
> Is state a reserved word? In official list of Firebird reserved
> words on www.ibphoenix.com it missing.
>
> PS. IBO version 4A2, Firebird WI-T0.9.4.103

The word is listed in IBO's list of reserved words, which is why you
get the error. But, as you noticed, not in the Interbase
documentation for 6.0 or 5.6). I cant find my previous version
documentation, so perhaps it used be a reserved word in an earlier
version.

You should be able to avoid the IBO error enclosing the parameter name
in double quotes (if you are using dialect 3).

HTH

Geoff Worboys
Telesis Computing