I have the following table:

CREATE TABLE A4(
COL INTEGER[0,10]
);

I then tried to create the following sp:

SET TERM ## ;

CREATE OR ALTER PROCEDURE sp_A4
RETURNS (
opCOL INT[0,10]
)AS
BEGIN
FOR SELECT COL
FROM A4
INTO :opCOL
DO
BEGIN
SUSPEND;
END

END ##

SET TERM ; ##

And it failed with:

Token unknown - line 3, char 12
[

Is this a known issue where arrays can't be data types in sp's or is there a
problem with the sp?

Rgds

Si Carter
http://www.tectsoft.net/