My Oracle Support Banner

Use Of Sequence In Analytic Function Results In ORA-02287: Sequence Number Not Allowed Here in 19c (Doc ID 2925735.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Below error after 19c upgrade:

SQL> create sequence my_seq;

Sequence created.

SQL> select object_name, object_type, max(my_seq.nextval) over (partition by object_type) from user_objects;

select object_name, object_type, max(my_seq.nextval) over (partition by object_type) from user_objects

*

ERROR at line 1:

ORA-02287: sequence number not allowed here

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.