DECLARE TYPE XX IS TABLE OF CHAR(1) INDEX BY BINARY_INTEGER; x XX; BEGIN SELECT 'X' BULK COLLECT INTO x FROM DUAL WHERE 1 = 0; DBMS_OUTPUT.PUT_LINE (x.COUNT); -- 0 END;