Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

krishnagopi614Oct 25 2013 — edited Feb 26 2020

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 22 2013
Added on Oct 25 2013
#adapter, #and, #business-process-management-suite, #database, #file, #in, #soa, #soa-process-management
0 comments
165 views