ORA-02014

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 Received on Thu May 30 2002 - 10:49:31 CDT