Sequence disallows order by
A call to a PRICE_S1 sequence in a query with an ORDER BY clause is disallowed, which typically occurs in an INSERT statement. Any attempt raises the following exception:
SELECT price_s1.NEXTVAL AS price_id * ERROR AT line 1: ORA-02287: SEQUENCE NUMBER NOT allowed here |
You need to remove the ORDER BY clause to eliminate the error.
Subscribe via RSS