here is what i need to take note today, select multiple rows into array, by using bulk collect into...

the code is here:

DECLARE
TYPE varray_type IS VARRAY(5) OF VARCHAR2(360 BYTE);
v2 varray_type;
BEGIN

select ..... BULK COLLECT INTO ..... from .....
WHERE .....
END;
/