|Subject||RE: [firebird-support] Listing current generator values, execute statement|
> 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."
Logging/Auditing Suite for InterBase and Firebird
Logging/Auditing Suite for Advantage Database Server