BULK COLLECT initializes collection

bulk_collect_no_rows.sql

-- Bulk collect leaves collection NOT NULL when no rows got
DECLARE
  nt NUMBER_TABLE; -- does not change if you initialize it like ':= NUMBER_TABLE()'
BEGIN
  SELECT 1
  BULK COLLECT INTO nt
  FROM DUAL
  WHERE 1 = 2;

  IF nt IS NULL THEN
    RAISE_APPLICATION_ERROR(-20100, 'nt is null');
  ELSE
    RAISE_APPLICATION_ERROR(-20100, 'nt is not null: ' || nt.COUNT || ' rows');
  END IF;
END;