Bug
Add Query Layer does not recognize the NOT NULL constraint.
| Bug ID Number | BUG-000116399 |
|---|---|
| Submitted | August 29, 2018 |
| Last Modified | September 19, 2024 |
| Applies to | ArcGIS for Desktop |
| Version found | 10.5 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Known Limit |
Additional Information
This is an Oracle limitation that a not null or a check constraint cannot be added on a view created based on a union for two tables. Describe the view itself from Oracle, the not null constraints are already gone: SQL> desc vtestnull Name Null? Type ----------------------------------------- -------- ---------------------------- MANDANT NUMBER(38) RISIKO_ID NUMBER(38) VN NUMBER(38)Workaround
This is a display problem. No workaround required.
Steps to Reproduce
Bug ID: BUG-000116399
Software:
- ArcGIS for Desktop
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