Inside a stored procedure i need to assign the contents of an
array-column from a table
to a local variable (using SELECT INTO).

How can I declare that variable?

the following declarations are not valid:

DECLARE VARIABLE MyVariable NUMBER(15,5) [0:13];

DECLARE VARIABLE MyVariable BASED ON MyTable.MyColumn;

DECLARE VARIABLE BASED ON MyTable.MyColumn MyVariable;

DECLARE VARIABLE MyVariable MyDomain ; -- where MyDomain =
NUMBER(15,5) [0:13])

TIA

Mike