FUNCTION  search_alll(p_genre IN VARCHAR2 DEFAULT NULL, p_year IN movies.year%TYPE DEFAULT NULL)
RETURN search_block_pkg.t_data
IS
    v_dataset_g search_block_pkg.t_data;
    v_dataset_y search_block_pkg.t_data;
    v_dataset search_block_pkg.t_data;
BEGIN
    v_dataset_g := search_block_pkg.search_for_genre(p_genre);
    v_dataset_y := search_block_pkg.search_for_year(p_year);
    
    
    SELECT *
    BULK COLLECT INTO v_dataset
       FROM TABLE(v_dataset_g) T1 INNER JOIN TABLE(v_dataset_y) T2 USING(id);
       RETURN v_dataset;
END;

SELECT *
    BULK COLLECT INTO v_dataset
       FROM TABLE(v_dataset_g) T1 INNER JOIN TABLE(v_dataset_y) T2 USING(id);
       RETURN v_dataset;