When attempting to connect to an Oracle database (non-geodatabase) from ArcGIS Pro, the following error message is encountered:
Underlying DBMS error[ORA-06550: line 1, column 62: PLS-00302: component 'Name' must be declared No extended error]
The database component (table, view or sequence) in the error message has an associated public synonym.
A synonym is an alternative name that references a table, view, or sequence in Oracle. ArcGIS cannot support synonyms, because ArcGIS will fully qualify (prefix) all table or view objects with the schema owner when referencing the object in the SQL statement.
Drop the public synonym from the Oracle database using the following SQL syntax:
DROP PUBLIC SYNONYM NAME