Error: ORA-00918: column ambiguously defined

Error Message

When executing a query using the ArcSDE SDK API, the following error displays:

"ORA-00918: column ambiguously defined"


The columns defined in the SELECT list of the query have the same name as any existing alias on the ArcSDE Table. For example, all ArcSDE Tables have the aliases AREA and LEN defined on the SHAPE column. Any query defined with the AREA or LEN column names in the SELECT list, fail and return this error.

Solution or Workaround

Use fully qualified column names in the query. This is done by using the table name as a prefix to the column name. For example, use the fully qualified column name CITIES.AREA in a query on a column named AREA in a table named CITIES.