Re: ORA-02014

misha wrote:

> i'm getting
>
> ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.
>
> when I do
>
> select N
> from TABLE
> where STAT = 1 for update nowait;
>
> now, TABLE is not a view but a valid table
>
> if I do
>
> select N
> from TABLE
> where SOMEOTHERFIELD = 1 for update nowait;
>
> it works fine; is it an oracle bug? please help
>
> I have Oracle 9i on Win2k.
>
> I would appreciate someone's help.
>
> Regards, Misha

Please post the definition(s) for the objects as well as the SQL that works and doesn't work.

And which version of 9i?

Daniel Morgan Received on Thu May 30 2002 - 11:07:31 CDT