Hi,

We have 2 users.
One is TABS which is owner of the application schema.
which has all the tables,procedures, packages.
And we have another user SAM , who is normal User.
When we connect to SAM and try to execute the procedure
which is owned by TABS. it is giving error.
We have checked all the privileges of SAM. We also given
execute privilage on that procedure TO SAM. But we are not able to findout the problem.This problem is for all procedures,
packages of TABS schema.
---------------------------------------------------------------
SQL> SHOW USER
USER is "TABS"
SQL>
SQL> CREATE PROCEDURE TESTPROC
2 IS
3 BEGIN
4 DBMS_OUTPUT.PUT_LINE('PROCEDURE TESTPROC IS EXECUTED');
5 END;
6 /

Procedure created.

SQL> EXECUTE TESTPROC;

PL/SQL procedure successfully completed.

SQL> GRANT EXECUTE ON TESTPROC TO PARESH;

Grant succeeded.


SQL> CONNECT SAM/SAM@TAB1D
Connected.
SQL>
SQL> EXECUTE TABS.TESTPROC;
BEGIN TABS.TESTPROC; END;

*
ERROR at line 1:
ORA-06550: line 1, column 12:
PLS-00302: component 'TESTPROC' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


------------------------------------------------------------------------------


Regards

Paresh