Hi,

> I know Jaybird 1.0.1 doesn't support array datatype.
>
> Anyway, is it possible to use with jaybird a selectable procedure
> which returns some integer values and an integer array value? I don't
> want to get this array value in my java application, I'll just
> retrieve the integer values.
>
> Could it be any problem?

You have to use following syntax:

SELECT myIntColumn FROM mySelectableProc(?, ...)

If you keep using {call ...} syntax, JayBird will throw an exception.
If using escaped syntax is a must, wrap your procedure with another one:

CREATE PROCEDURE myWrapperProcedure (....) RETURNS (myIntColumn INTEGER)
AS BEGIN
SELECT myIntColumn FROM mySelectableProc(...) INTO :myIntColumn;
/* This is needed only if you want it to be selectable */
SUSPEND;
END

Roman