Integration

I have cretaed a simple BPEL process to read data from a file and insert data into a table through PL/SQL API.

For calling PL/SQL API, I used Database adapter.

This process has a file adapter to read file, a recieve activity to get data from file adapter, a database adapter to call PL/SQL API to insert data, an invoke activity to call database adapter and a transfor activity to transform a data between recieve and invoke activity.

I can see the data in ivoke message.

The process succeeds but it always inserts null to the database table.

I have also tried using Oracle Applications Adapter but no luck. If I use direct insert into table without API, then it works fine.

Any help is appreciated.

Thanks
Ranajit