Select Oracle Sequence from DUAL for Subsequent Insert

[Former Member]

We are migrating an Idoc to Database scenario over to XI and ran into the following situation. The existing interface does the following:

1) Selects an oracle sequence nextval from dual (ex. "select user_seq.nextval from dual") to obtain a sequence key.

2) Uses the key from #1 to insert a line into a header table

3) Uses the key from #1 to insert multiple lines into a details table

What is the best way to model this into XI using JDBC receivers? I was thinking that a ccBPM would be required to perform #1, then using that value in a combination of #2/#3 in the same JDBC receiver. This is starting to get a little complex and I was wondering if there was a better way? We are not opposed to using Oracle stored procedures, but we are not sure how to send this kind of structure into a stored proc where it can all be used in the same transaction.

Thanks

Peter

[Former Member · Accepted solution]

Hello,

Use JDBC look up in the mapping to get the sequence and pass it to the key to header and Item tables.

Regards,

Sreenivas.