"PLS-00201:identifie r' <User>.<Procedu re Name> ' must be declared"

[sravankumar]

Hi,
I am trying to execute Stored Procedure that is in the other user.

Geting the "PLS-00201:identifie r' <User>.<Procedu re Name> ' must be declared" . what are the pre requsites to access the other user objects. Can any one help me to solve this problem.
Regards
Sravan

[debasisdas]

Since the procedure exists in another schema u have no previledgeson it.
To solve the poblem

Method 1.
----------------
From the other user first grant EXECUTE ON the procedure to your user.

Method 2.
-----------------
Use a dblink that connects to the other user.

Hope u find the solution