ORA-02287: sequence number not allowed here

[Former Member]

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

[aashish_sinha · Accepted solution]

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 · Accepted solution]

Hello Aashish,

Thank you for your answer.

Can you suggest me some alternatives?

Elad

[GabrielSagaya]

The problem is caused by your group by clause.

The solution is to use a subquery to group the data and then use it result set like a table

http://www.dbforums.com/printthread.php?t=380997

[Former Member]

Hi Elad ,

It is not issue with SAP XI interface . You are getting this error when you try to insert data into Oracle data base . Please check your insert statement , which is getting built in JDBC adapter .

Please refere this for generating the insert statement with out sequence number ---

http://www.orafaq.com/wiki/ORA-02287

Regards,

Kishore