ERROR
ORA-00600 error
Error Message
This is a bug with Oracle 9i software that is causing UNION ALL to fail when using bind variables.
Cause
This is a known issue.
Solution or Workaround
In Oracle 9i, the default for the parameter '_push_join_union_view=' is true. Oracle suggests the following work-around:- Set this parameter to ‘false’:
_push_join_union_view=false - Restart Oracle so this parameter will take effect.
Refer to the link for ESRI System Requirements in Related Information below to research the versions of Oracle that are compatible with different operating systems.
This bug is scheduled to be fixed in Oracle 9.2.
Article ID: 000004847
Software:
- Legacy Products
Receive notifications and find solutions for new or common issues
Get summarized answers and video solutions from our new AI chatbot.
Related Information
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