Received sequence from Oracle database

[Former Member]

Hello

I have scenario from RFC to Oracle database.

I am looking for the way to insert data to the database according to the sequence.

I try to use with the sentence SEQ.NEXTVAL and is not allowed.

Have a way to receive the sequence from database?

Elad

[aashish_sinha · Accepted solution]

Hi,

Use this blog to generate the sequence number at mapping time and map it to the resulting structure,

Hope this will help you to overcome this problem.

Regards

Aashish Sinha

PS : reward points if helpful

[Former Member · Accepted solution]

Hello Aashish,

Thank you for your answer.

I am looking for the way to receive the sequence fro the Oracle database.

Elad

[GabrielSagaya]

check pulin's reply

also check bhavesh reply

[Former Member]

Hello,

Thank you for your answer can you give me advise how to Write a stored procedure ?

Elad