Integration

Hi -

I want to know how to run stored procedure using jca adapter in OSB11g.

I am new to stored prcoedure,will be great if you could share some example on it as above.

Req: Single input xml will be posted on queue ,need to perform 3 DB operation (with same input):

1.Insert operation to insert master table contents.
2.select the primary key column value from master table for the last inserted record.
3.Need to insert primary key column value + other fields frm same xml file to child table.

Pls assist me on how to create a simple stored procedure and to run the same with OSB 11g.I am familiar with creation of DB adapter using Jdeveloper,we have option to perform insert and to call stored procedure here,will it be useful for this scenario?