473,326 Members | 2,126 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

"PLS-00201:identifier' <User>.<Procedure Name> ' must be declared"

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

Geting the "PLS-00201:identifier' <User>.<Procedure 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
May 8 '07 #1
1 27925
debasisdas
8,127 Expert 4TB
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
May 8 '07 #2

Sign in to post your reply or Sign up for a free account.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.