Writing a stored procedure each time you want to generate a unique number is a waste. Especially when you can do it using SQL.

SELECT
  GEN_ID(GENERATORNAME, 1)
FROM
  RDB$DATABASE

Average rating: