Re: Ora-942 in stored procedure

sounds like a case of case. Make sure you access your tables between double-quotes, such as

insert into "table2" select col1, col2 from schema2."table1";

try renaming all your tables to upper case and you'll be able to access them without the quotes.

it's a shame oracle never came out with a different error-code.

Jeff

dasingh_at_hotmail.com (DA Singh) wrote in message news:<78340f33.0311100847.45d99306_at_posting.google.com>...
> 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 Fri Nov 14 2003 - 16:56:02 CET