Code Search crashes program when both Triggers and Views object type options are selected. Selecting these options individually does not crash the program and search completes successfully.
When Triggers and Views options are both selected, SQL Navigator runs as SQL statement in the background on User_Triggers and User_Views. SQL Navigator uses a UNION ALL operator to run a single query on both views. Both views contain LONG columns. Oracle 8.1.7.4 and Oracle 7.3 has been known to have an issue with using UNION ALL operator with LONG data types. An "end-of-file communication" issue has been reported by Oracle in this case.
Upgrade Oracle client or use a different version.
OR
Choose Triggers and Views options separately.
