SQL & PL/SQL

Hi,

I have a sql query which I'm trying to put into a store procedure. The problem is I cant get the stored procedure to compile. The sql works fine in SQL window. Even when I run the full query below, it works no problem from SQL Plus.

CREATE OR REPLACE TYPE BCMD_TMP AS TABLE OF VARCHAR2 (4000)

open p_cursor for
select column_value
from bcmd_companytemp, TABLE(BCMD_TMP (compno, compname));

I'm not quite sure what the error means but I'm guessing it is the TABLE part.

Here is the full SQL.
select column_value
from bcmd_companytemp, TABLE ( BCMD_TMP (compno, compname, address,citygroupid,prov,postal,phone,toll_free,fax,
exportfax,experienceid,countries,exportstartdate,potential,e_mail,web_site,words,products,sectors,sales,
empsizeid,employees,salut,firstname,lastname,position,contareacode,contphone,extension,
contemail,contactno,salut2,firstname2,lastname2,position2,contareacode2,contphone2,extension2,contemail2,
contactno2,priority,manlocals,manu_in_bc))
where tempid = 24


Thanks for you help.
Will