TT-03206
CURRVAL or NEXTVAL not allowed in select with distinct, aggregate function, group by or order by
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 SELECT statement with the DISTINCT operator, or in aggregate functions in a GROUP BY clause or an ORDER BY clause in a SELECT statement. For more information, see CREATE SEQUENCE in Oracle TimesTen In-Memory Database SQL Reference.
Additional Information
TimesTen cannot perform the operation.
TT-03206
CURRVAL or NEXTVAL not allowed in select with distinct, aggregate function, group by or order by
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 SELECT statement with the DISTINCT operator, or in aggregate functions in a GROUP BY clause or an ORDER BY clause in a SELECT statement. For more information, see CREATE SEQUENCE in Oracle TimesTen In-Memory Database SQL Reference.
Additional Information
TimesTen cannot perform the operation.
TT-03206
CURRVAL or NEXTVAL not allowed in select with distinct, aggregate function, group by or order by
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 SELECT statement with the DISTINCT operator, or in aggregate functions in a GROUP BY clause or an ORDER BY clause in a SELECT statement. For more information, see Incrementing SEQUENCE values with CURRVAL and NEXTVAL in the Oracle TimesTen In-Memory Database SQL Reference.
Additional Information
TimesTen cannot perform the operation.
