Re: Oracle error for sequence

From: Sergey Adamenko <asv_n_o__s_p_a_m_at_softline.kiev.ua>
Date: Fri, 16 May 2003 11:44:01 +0300
Message-ID: <3ec4a571$1@ns>

"Mohammad" <mhakimjavadi_at_hotmail.com> wrote in message news:cc59b627.0305151150.11c35b3_at_posting.google.com...
> Hi
>
> I'm spooling data to a file and using a sequence number generator to number
> each record and I get an ORA-02287 error. When I look up the error, it
> tells me this:
>
> ERROR at line 17:
> ORA-02287: sequence number not allowed here
>

Sequence number not allowed in SELECT-s with GROUP BY, ORDER BY, UNION clauses.

Sergey Adamenko Received on Fri May 16 2003 - 03:44:01 CDT