Forum Stats

  • 3,836,822 Users
  • 2,262,196 Discussions


how to transformed data from File to DB but the data to be insert two tables parallel?

krishnagopi614 Member Posts: 63

Hi friends ,I am new to Oracle SOA ,I have one requirement  for the project

actually in these project

1.I have to read three different types of files (Employee info,Purchase Order Info,Salaes Order Info) through file adapter these records are to be store in  data base 

transaction table.In these transaction table contains WHO columns and payload  with clob data type which contains each  record  in xml form.

2. Now I have to  take these payload data  which is in xml form and store   in the respective table(employee or PO or SO) .I have to call these in dynamically.

so please give me ideas and suggesstions ,,

thanks in advance

This discussion has been closed.