Recently this question was asked to me as a comment to one of my post. I have replied to the comment. I also felt to post this as a blog so that it can prove beneficial to others. Here it goes...
The function orcl:sequence-next-val takes 2 parameters. It return the next value of an Oracle sequence. It is similar to sequence generation what we see in Oracle SQL.
How to proceed:
First of all you need to drag that function to the tranformation swimlane.
Create a database sequence in Database, say,TEST. This will be the first parameter for the orcl:sequence-next-val function.
The second parameter will be your database connection details, i.e. the database in which your source table is defined.
Suppose your database is having details as:
so the second parameter will look like this:
or for the second parameter you can add a datasource entry in data-sources.xml file under soa_home\j2ee\oc4j_soa\config.
Say the datasource name is BPEL_DBS. so the function will look like,
After doing this, map it to the destination field.
Your are done...Happy Learnings...