> The problem seems to be at this line:-
> BEN_ID = GEN_ID( BENID_GEN, 1 );

No, it seems that the problem is here:

> set term ^ ;
> CREATE PROCEDURE INSERT_BEN AS BEGIN EXIT; END ^
>
> SET TERM ; ^

^^^^^^^^^^^^^^^^^^

> ALTER PROCEDURE INSERT_BEN ( BENEF_ID VARCHAR(15)

You should remove this SET TERM statement.
Or, alternatively, add another SET TERM after this one:

set term ^ ;
CREATE PROCEDURE INSERT_BEN AS BEGIN EXIT; END ^

SET TERM ; ^ <------------- remove this _OR_
SET TERM ^ ; <------------- add this

ALTER PROCEDURE INSERT_BEN ( BENEF_ID VARCHAR(15)

etc...

Hope, this will help...


Best regards,
Alexander Khvastunov

IBExpert - The Most Expert for InterBase and FireBird
http://www.ibexpert.com