hI
Iam not able to compile procedure sucessfully . it says errors pls-00302 foo must be declared. But same thing working in different user (same instance,same database).

Scenario as follows

1) connect alumni/o@test

create table foo (id number);

insert into foo values(1);

commit;

grant all on foo to faismgr;


2) connect faismgr/o@test

create procedure as follows


create procedure bogus is
my_values alumni.foo.id%TYPE;
cursor c1 is
select id from alumni.foo;
begin
open c1;
fetch c1 into my_values;
close c1;
end;
/
show error



SQL> show error
Errors for PROCEDURE BOGUS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/13 PL/SQL: Item ignored
2/20 PLS-00302: component 'FOO' must be declared
7/3 PL/SQL: SQL Statement ignored
7/17 PLS-00320: the declaration of the type of this expression is
incomplete or malformed


but same thing worked in some other user called SATURN.

What could be problem? Any privs or roles missing in FAISMGR schema

any help would be appreiciated