ORA-06564: object does not exist Errors - ORDS

Question

I am looking for a little bit of help here. We had a web-service defined and I created some new URI templates and these are working as expected as when I call them from the apex application they are returning the JSON object as expected. The problem is I was looking at the log files in Tomcat, we have a lot of entries for ORA-06564: object does not exist for all the new URI templates I created.

17-Sep-2018 00:09:48.199 SEVERE [ajp-apr-8009-exec-1]
oracle.dbtools.apex.Procedure.resolveNameNew ORA-06564: object XXX does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 156
ORA-06512: at line 1
java.sql.SQLException: ORA-06564: object XXX does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 156
ORA-06512: at line 1

I am just wondering if I have not defined something or I missed something in the ORDS configuration.

Does someone have some idea in regards?

Answer 1

ORA-06564: object does not exist, The named object could not be found. Either it does not exist or you do not have permission to access it.

Resolution: The database user that you were trying to access from the application does not have enough privilege's. Please execute the below grant to give permission to your database object.

GRANT EXECUTE ON "YOUR DB OBJECT" TO DBUSERID;