I am getting the following error :-
------------------
PLS-00201: identifier '<schema>.ABC_DROP_INDEX_PRC' must be declared
------------------
Can anyone guide me on resolving this issue??
Thanks.I'm guessing this question belongs in the SQL Server forum. If not the moderators will move it to a more appropriate forum.
ADMIN|||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.|||It looks like it is an Oracle error involved right limitations.|||
Quote:
Originally Posted by iburyak
It looks like it is an Oracle error involved right limitations.
Send me a PM if you need it moved again.|||Let's see his respond first.
Sometimes they never come back to view respond at all ... :)|||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.
No comments:
Post a Comment