Subject Data type of rdb$db_key
Author Pere Vilàs
Hi,

SQL> select rdb$db_key from articulos;

DB_KEY
================

0000008500000001
0000008500000002

but

SQL> select * from proves('ARTICULOS');

NUM
================

à
à

and

CREATE PROCEDURE PROVES( TAULA VARCHAR(20) )
RETURNS ( NUM char(16) )
AS
begin
FOR execute statement 'select rdb$db_key from '||taula into :num DO
SUSPEND;
end

It doesn't work with integer, char(100), bigint, ... It is a problem of
execute statement?.

Pere