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:
- Set this parameter to ‘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.