I Created a new package in a schema let's call it "A" and was trying to run a function in that package using my own ID.
Oracle was showing me this error "pls-00201 identifier must be declared " , after a little research I found that I had to grant execute on this package to my user ID otherwise Oracle will show me the above error so I executed below command as the Schema owner of "A"
grant execute on A to My_User_id
and only then I was able to run the functions in the package "A"
Thanks to the below link
http://www.dbasupport.com/forums/showthread.php?53493-DBMS_JOB-errors-PLS-00201-identifier-package-proc_name-must-be-declared
Let's define the steps to be done here to avoid error "pls-00201 identifier must be declared "
Oracle was showing me this error "pls-00201 identifier must be declared " , after a little research I found that I had to grant execute on this package to my user ID otherwise Oracle will show me the above error so I executed below command as the Schema owner of "A"
grant execute on A to My_User_id
and only then I was able to run the functions in the package "A"
Thanks to the below link
http://www.dbasupport.com/forums/showthread.php?53493-DBMS_JOB-errors-PLS-00201-identifier-package-proc_name-must-be-declared
Let's define the steps to be done here to avoid error "pls-00201 identifier must be declared "
- Create a package
- Grant execute access to your user or role to that package
- Try to run any pricedure in that package , you should be able to do it now as you have been granted the execute rights on it.