Ora-942 in stored procedure

Hi,
I have a stored procedure that tries to select from a table owned by another schema -
create or replace procedure schema1.procedure1 as
insert into table2
select col1, col2
from schema2.table1;
end;
/

And I get the Ora-942 error - Table or view does not exist. I can select from the table from the SQL prompt, when logged in as schema1.
Are there some permissions that need to be set? The Oracle version is 9.2.0.3.0
Thanks,
D A Singh Received on Mon Nov 10 2003 - 17:47:13 CET