cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-02287: sequence number not allowed here

Former Member
0 Kudos

Hello,

I have scenario from RFC to Oracle database.

In ID I insert to constant:

HR_AWARDS_ID_SEQ.NEXTVAL

When I run this scenario I received this error in RWB:

ORA-02287: sequence number not allowed here

Any idea how to solve this problem?

Elad

View Entire Topic
aashish_sinha
Active Contributor
0 Kudos

Hi,

This error come beacause of the specified sequence number (CURRVAL or NEXTVAL) is inappropriate here in the statement. So plese remove the nextval from HR_AWARDS_ID_SEQ.NEXTVAL and use some alternaative.

Regards

Aashish Sinha

PS :reward points if helpful

Former Member
0 Kudos

Hello Aashish,

Thank you for your answer.

Can you suggest me some alternatives?

Elad