-
Procedure not working
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|