Hello NAS,

>>N> why it's not work :
>>N> id_xx=gen_id(:param1);
>>N> param1 is varchar
>>N> I use Firebird 1.52
>>AFAIK, you can't use such construction. As a workaround refer to
>>EXECUTE STATEMENT (see release notes), something like
>>-----
>> stmnt = 'select gen_id(' || param1 || ', 1) from rdb$database';
>> execute statement stmnt into :id_xx;

N> I get SQL error code = -902
N> wrong request type in EXECUTE STATEMENT XXX
Probably the type of id_xx is incompatible with the generator value,
which is int64?
Could you post the way you try to use it please? (I mean, the stored
procedure source code)


--
Best regards,
Pavel Menshchikov
http://www.ls-software.com