Getting Error "ORA-04042: procedure, function, package, or package body does not exist" while granting access to Other Users

utPLSQL / utPLSQL-cli

Command line client for invoking utPLSQL

Apache License 2.0

40 stars 15 forks source link

Getting Error "ORA-04042: procedure, function, package, or package body does not exist" while granting access to Other Users #194

Closed venkat-kasula closed 3 years ago

venkat-kasula commented 3 years ago

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"

pesse commented 3 years ago

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.

venkat-kasula commented 3 years ago

@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

venkat-kasula commented 3 years ago

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.