TimesTen Error Messages

TT-03208

CURRVAL or NEXTVAL not allowed in where clause


Cause

The specified sequence value CURRVAL or NEXTVAL is not allowed in your statement. The use of a sequence is limited.


Action

Do not use CURRVAL or NEXTVAL in the WHERE clause in the SELECT, UPDATE or CREATE VIEW SQL statements. However, CURRVAL is allowed in the SELECT WHERE clause. For more information, see CREATE SEQUENCE in Oracle TimesTen In-Memory Database SQL Reference.


Additional Information

TimesTen cannot perform the operation.