English

Bug: Applying a spatial filter on a view created with sdetable in Oracle returns "ORA-00918: column ambiguously defined"

Description

Applying a spatial filter on a view created with sdetable returns the following error:

"ORA-00918: column ambiguously defined".

This may happen when a view is created with sdetable -o create_view when two tables are joined in the view's definition.

Code:
sdetable -o create_view -T land_view -t parcels,land -c parcels.objectid,parc
els.shape,parcels.parid,land.taxyr,land.ltype,land.parid -w "parcels.parid=land.parid(+)"


When the view is added to ArcMap and the session zooms into an area (performing a spatial query), an underlying Oracle error is encountered.

Cause

Internally, ArcSDE generates a query with an invalid attribute that is not fully qualified to reference one of the two tables defined in the view.

Workaround

Currently there is no workaround that addresses this issue.