SQL & PL/SQL

Hello

I'm receiving the above error message at the BULK COLLECT point. I've pasted all relevant code below - any help much appreciated. This has got me stumped....

Thanks in advance
Tim

create or replace type PROG_MEDIA_TYP as object
(episode_id number,
house_number varchar2))

create or replace type t_all_prog_medias as TABLE of PROG_MEDIA_TYP

v_All_Prog_Media t_All_Prog_Medias ;

SELECT DISTINCT Prog_Media_Typ(Pm.Episode_Id,
Substr(Pm.House_Number, 1, 8)) BULK COLLECT
INTO v_All_Prog_Media
FROM Prog_Media Pm;