Bug
Unable to query REST API when using a referenced service coming from an Oracle database or file geodatabase for a text field; the text is treated as a string, causing the query to fail when attempting to use ST_CODE = 54 without quotes due to ArcGIS Server's standardized queries enforcing SQL-92 syntax.
| Bug ID Number | BUG-000174956 |
|---|---|
| Submitted | March 11, 2025 |
| Last Modified | July 7, 2025 |
| Applies to | ArcGIS Pro |
| Version found | 2.9.12 |
| Operating System | Windows OS |
| Operating System Version | 11.0 64 bit |
| Status | As Designed |
Additional Information
The behavior in which the REST query ST_CODE = 54 fails without quotes but succeeds with ST_CODE = '54' is expected and by design. This is consistent with our official documentation on standardized queries in ArcGIS Server, which enforces SQL-92 syntax for security purposes (see: https://resources.arcgis.com/en/help/main/10.2/index.html#//015400000641000000).Workaround
Immediate Fix:
- Use: ST_CODE = '54'.
- Effect: Resolves the error regardless of settings, as validated in the test report.
Long-Term Consistency:
- Verify Settings: Path: system > properties > update.
- Confirm: "standardizedQueries": "true".
- Action: Keep enabled for security.
- Avoid Disabling: Disabling ("standardizedQueries": "false") allows lax syntax but risks SQL injection.
Steps to Reproduce
Bug ID: BUG-000174956
Software:
- ArcGIS Pro
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App