ERROR

Underlying DBMS error[ORA-06550: line 1, column 62: PLS-00302: component ' ' must be declared No extended error]

Last Published: October 3, 2022

Error Message

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]
error message

Cause

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.

Solution or Workaround

Drop the public synonym from the Oracle database using the following SQL syntax: 

DROP PUBLIC SYNONYM NAME

Article ID:000028484

Software:
  • ArcGIS Pro 3 0
  • ArcGIS Pro 2 8 x
  • ArcGIS Pro 2 7 x
  • ArcGIS Pro 2 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options