Re: Sequence Error ORA-02287

Do not use a sequence in a where-clause, a query with an order by, group by, distinct, a set operation, an aggregate function, in a delete, in a view, or anywhere other than an insert, update, or select.

Please look in Oracle8i SQL Reference for the rules on when to use sequence values CURVAL and NEXTVAL.

-- 
Message posted via http://www.dbmonster.com