ERROR

ORA-00600 error

Last Published: April 25, 2020

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:

  1. Set this parameter to ‘false’:

    _push_join_union_view=false
  2. 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.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options