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.