PLS-00201 Error

[Prasenjit]

Hi,

I am getting the following error :-
----------------------------------------------------------
PLS-00201: identifier '<schema>.ABC_D ROP_INDEX_PRC' must be declared
----------------------------------------------------------
Can anyone guide me on resolving this issue??

Thanks.

[MMcCarthy]

I'm guessing this question belongs in the SQL Server forum. If not the moderators will move it to a more appropriate forum.

ADMIN

[iburyak]

I need more info on it. What did you do? What statement was executed when you recieved this error? Which program and as much as possible.


Thank you.

[iburyak]

It looks like it is an Oracle error involved right limitations.

[MMcCarthy]

It looks like it is an Oracle error involved right limitations.

Send me a PM if you need it moved again.

[iburyak]

Let's see his respond first.
Sometimes they never come back to view respond at all .... :)

[Prasenjit]

Hi,
Thanks to all for the suggestions provided, specially the last one!!
Wel, the answers was needed a little bit urgently and so i thought that i could get a reply from this forum.
I was able to fix the problem occuring. As stated earlier, it was a problem related to the access only...
"The rules for accessing other users objects are different when COMPILING
procedures/functions/packages.
Grants must be given directly, not through a role, to the compiling
usercode
(DBA is a role).
Normal rules apply when executing"
.....
So i had to Grant privileges to one of the access_role to be able to execute procedure so it should work now.
--------
Thanks anyways.