CREATE OR REPLACE TYPE TYPE_ROW AS ROW (
	"ID" INTEGER,
	"DATE1" TIMESTAMP,
	"DATE2" TIMESTAMP,
	"NAME" VARCHAR(20))
@

CREATE OR REPLACE TYPE TYPE_ROW_ARR AS TYPE_ROW  ARRAY[]
@

....
DECLARE VAR_ARRAY TYPE_ROW_ARR 
....
SELECT ARRAY_AGG(T.ID), ARRAY_AGG(T.DATE1), ARRAY_AGG(T.DATE2), ARRAY_AGG(T.NAME)
--либо может ARRAY_AGG(T.ID, T.DATE1, T.DATE2, T.NAME)
INTO VAR_ARRAY 
FROM TABLE1 AS T

ARRAY_AGG cannot be used to produce an associative array or an array with a row element data type (SQLSTATE 42846).

....
DECLARE VAR_ARRAY TYPE_ROW_ARR 
....
SELECT T.ID, T.DATE1, T.DATE2, T.NAME
BULK COLLECT INTO VAR_ARRAY 
FROM TABLE1 AS T

SQL0104N  Обнаружен неправильный элемент "COLLECT" после текста