This discussion is archived
0 Replies Latest reply: Feb 21, 2013 10:35 PM by user11189306 RSS

Reg: File Adapter

user11189306 Newbie
Currently Being Moderated
Dear team,

Oracle SOA version:11.1.1.5

We are reading a csv file with 100 records with "Publish messages in Batch " value =10 and archiving the file.
So reading a file is generating 10 instances.

In each bpel instance we are inserting data (10 records from file read) to Database.

After 5 bpel instances are successfully processed, from 6th instance database is throwing remote exception.

So our requirement is capture the data for failed bpel instances and write to a outbound file.

In catch block of remote exception , we are invoking the outbound file adapter which writes the data to a file in "append mode".

So for the all the failed bpel instances , we are writing data to same file.

But we need the file headers as 1st row in the file followed by file data.

how to get the file headers as 1st row of the outbound file ....presently we are gettiing only data from failed bpel process.

For example for emp.csv inbound file if headers are
empname,empid,Design

we want same headers for outbound file
empname,empid,design


Please suggest

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points