Subject RE: [firebird-support] Listing current generator values, execute statement
Author Thomas Steinmaurer
> Try "NUMERIC(18,0)" or "BIGINT" as the output type.

Not in a dialect 1 database. ;-)

Bob, I posted something similar in firebird-devel on 12.01.2004
in the thread:

"Execute Statement / gen_id(...) - Returned ..."

I quote Alex Peshkov's reply:

"Current implementation of EXECUTE STATEMENT doesn't support _ANY_
automatic type conversion. You should use cast(gen_id(...) as int) if
you really need it in your SP."

Thomas Steinmaurer

Logging/Auditing Suite for InterBase and Firebird
Logging/Auditing Suite for Advantage Database Server