Select Layer by Attributes for a Date Field is not NULL fails (invalid expression) even validating succeeds - Enterprise DB - Oracle 11g

682
2
03-27-2017 01:12 AM
ReginaldoPaderon
New Contributor III

ArcGIS Pro 1.4

DB:  Oracle 11g

Run Select Layer by Attribute on a Date Field ( is NOT NULL or is NULL) even successfully validating.  Error ,

 ERROR 000358: Invalid expression
Failed to execute (SelectLayerByAttribute).

selectlayerbyattribute‌

Sorry, cant delete this post.  pls ignore this as i tried the same in ArcMap and it throws some Oracle error.  The problem is this data is not ours.   we can not work on it.  a copy of this in our own database is fine both for ArcPro and Arcmap.

Tags (1)
0 Kudos
2 Replies
DanPatterson_Retired
MVP Esteemed Contributor

marked as Assumed Answered to let it float with your comments.

0 Kudos
ReginaldoPaderon
New Contributor III

Hi Dan,

      Perhaps, Pro can have the same detailed error message ( stating the Oracle number error etc ) as that of ArcMaps...As it is now, Pro's  message was only " ... invalid SQL expression .. ".

Just a suggestion.

0 Kudos