> I want to array data type in stored procedure.

...

> Is it possible ????
> When I try to do it, I failed....

I thought it would allow you to declare such a variable - its just
that you cant use it (without specialised UDFs).

That might sound bizarre, but that is the limitation in IB/FB. Array
data types can only be used via the API, not via the trigger/procedure
language.


Incidently. When you have a question relating to code inside stored
procedures, and triggers - it is a good bet that it is an
Interbase/Firebird specific question. As such you will get the
quickest and most appropriate responses from the IB_Support list.

--
Geoff Worboys
Telesis Computing