TimesTen Error Messages

TT-03207

CURRVAL or NEXTVAL not allowed in subquery of update, delete or select


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 a subquery of an UPDATE, DELETE or SELECT statement. References to CURRVAL and NEXTVAL are allowed in main query statements. For more information, see CREATE SEQUENCE in Oracle TimesTen In-Memory Database SQL Reference.


Additional Information

TimesTen cannot perform the operation.