Hi,
I am current using jdbc adapter service to insert parts of xml structure into different tables of the same database.The data from a single document type goes into around 10 tables.There are around 15 different document types and hence the number of adapter services created for insert is getting too large.I want to know which is the best way of handling this situation.Creating insert adapter for each table is the way which is followed right now.I am also considering writing pl/sql procedure and passing the xml as a whole to it for processing.Any help on the best practice/approach is much appreciated.
Thanks