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.


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’:

  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.

Related Information