> I have made this test procedure to verify if is working:
>
> CREATE PROCEDURE T2 (
> T VARCHAR(20))
> RETURNS (
> IDN VARCHAR(30),
> IDL INTEGER)
> AS
> DECLARE VARIABLE STRSQL VARCHAR(50);
> begin
> strsql='select loc_id, loc_name from '||T;
> for execute statement :strsql into :idl, :idn do
> begin
> suspend;
> end
>
> end
>
> I pass table name (SYS_LOCATION) and I get this error message:

The STRSQL is too small, change the definition to VARCHAR(100) and try
again.

Sean