Re: Full Join Problem

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Tue, 04 Jan 2005 21:56:04 +0000
Message-ID: <mu3mt0pcco377ua0gavsh64dlcdnm4kd2g@4ax.com>

On 4 Jan 2005 06:55:47 -0800, "pbewig_at_swbell.net" <pbewig_at_swbell.net> wrote:

>I am using Oracle 9.2.

Which minor version?

>I am having trouble writing a full join of
>two sub-queries. The join looks like this:
>
>select *
>from (select ...) a
>full join (select ...) b
>on a.xxx = b.xxx
>and a.yyy = b.yyy
>
>This causes an ORA-600 internal error.

ORA-600 indicates an Oracle bug. There were plenty of them in the ANSI join support in early versions of Oracle 9.0 and 9.2. A lot of them are fixed in later versions - can you upgrade?

(Although having said that, 9.2.0.6 introduces a new bug relating to FULL OUTER JOINS...)

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Received on Tue Jan 04 2005 - 15:56:04 CST