Re: Incorrect result from VIEW in Oracle 8i Lite

From: Ruud Laanbroek <ruudl_at_commotio.nl>
Date: 13 Aug 2002 07:50:06 -0700
Message-ID: <72f6e38f.0208130650.2de440f1@posting.google.com>

Yes.. I am quite sure... I just tried it again... It really seems to be a problem with Oracle 8i Lite...

BTW... this problem occurs on different Oracle 8i Lite installations. First on different 4.0.0.1 installations, one of which I upgraded with a patch to 4.0.0.2.19, after which the problem still occured.

Ruud

Richard Foote <Richard.Foote_at_oracle.com> wrote in message news:<3D58B65F.D37962EA_at_oracle.com>...
> Hi Ruud,
>
> When it works when you don't use the view, are you sure you are adding
> the additional AND condition *after* the NOT EXISTS AND condition list
> (ie. after the last ")" ) as would the view and not within the NOT EXIST
> condition ?
>
> Cheers
>
> Richard
>
Received on Tue Aug 13 2002 - 09:50:06 CDT