Re: Oracle error for sequence

From: Sergey Adamenko <asv_n_o__s_p_a_m_at_softline.kiev.ua>
Date: Fri, 16 May 2003 12:52:14 +0300
Message-ID: <3ec4b56f$1@ns>

The SQL is in the root message of this thread. I decided not include it into my reply. It's rather massive. And contains <SEQ>.NEXVAL with cause parse error.

Best regards,
Sergey Adamenko

"Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message news:yT1xa.13575$pK2.18502_at_news.indigo.ie...
> Post the Nasty Nasty SQL please .

>
> "Sergey Adamenko" <asv_n_o__s_p_a_m_at_softline.kiev.ua> wrote in message
> news:3ec4a571$1_at_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 - 04:52:14 CDT