Get the result value of the sequence in output(Custom SQL)

, ,
1

I am trying to create a insert custom SQL statement and want to fetch SEQUENCE.currval in to the result/output. How can i recover the value of the oracle sequence in output.

Thanks,
Sri

2

You mean get sequence.nextval in the Adapter service output result var and use that value for multiple inserts?

Check this also for syntax and touch base with your SQL dba:

HTH,
RMG