Re: Sequence Error ORA-02287
From: Deepa balu via DBMonster.com <forum_at_DBMonster.com>
Date: Mon, 21 Mar 2005 13:27:24 GMT
Message-ID: <335dd1177542431b86115ae8bab62ad9_at_DBMonster.com>
Date: Mon, 21 Mar 2005 13:27:24 GMT
Message-ID: <335dd1177542431b86115ae8bab62ad9_at_DBMonster.com>
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.comReceived on Mon Mar 21 2005 - 14:27:24 CET