Getting Error "ORA-04042: procedure, function, package, or package body does not exist" while granting access to Other Users
venkat-kasula opened this issue · 3 comments
HI All,
we have the installed the UTPLSQL on the Oracle Instance with the help of DBA team , while providing grant access to other users we are getting below error
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist
Command Used: sqlplus @create_synonyms_and_grants_for_public.sql UTPLSQL
Kindly let us know where we did wrong & what is the next step to resolve the issue.
We followed the same steps as provided in Documentation "http://utplsql.org/utPLSQL/latest/userguide/install.html"
In order for us to be able to help you, please provide an example of the test-package, the package/function to be tested and your exact call to utPLSQL.
@pesse sorry for the delay in replying.
We are not trying to execute the packages. But instead we got this error post installing & granting access to the Other Users
Error occurred while executing the below command :
sqlplus @create_synonyms_and_grants_for_public.sql UTPLSQL
Installation was unsuccessful due to the User Table doesnt exist. Issue was no properly displayed until we went into install.logs. Hence corrected the isue.