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

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

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:
http://dba.stackexchange.com/questions/2978/in-oracle-how-do-i-save-a-sequence-nextval-in-a-variable-to-be-reused-in-multipl

HTH,
RMG