If I try to create a definition query that has invalid syntax, ArcGIS Pro displays a generic error message:
The SQL expression has invalid syntax.
![Bud_0-1670779398122.png Bud_0-1670779398122.png](https://community.esri.com/t5/image/serverpage/image-id/58242i1E854C1020E5B2B3/image-size/medium?v=v2&px=400)
That generic error message isn't very helpful.
The database is likely throwing a more descriptive error message behind the scenes:
ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:
Error at Line: 5 Column: 13
SQL Developer:
![Bud_2-1670779724431.png Bud_2-1670779724431.png](https://community.esri.com/t5/image/serverpage/image-id/58244iFE2CDED325BCEBFA/image-size/medium?v=v2&px=400)
Could ArcGIS Pro be enhanced so that the more descriptive database error messages are displayed in the definition query window? That would help with debugging.
Thanks.
ArcGIS Pro 2.6.8; Oracle 18c 10.7.1 enterprise geodatabase
and ArcGIS Pro 3.0.3; mobile geodatabase