Subject | Data type of rdb$db_key |
---|---|
Author | Pere Vilàs |
Post date | 2003-11-28T10:48:36Z |
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
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