I need to update a large number of records (~50000) into oracle DB table. What is the best way of doing this via webMethods developer? We are using IS 7.1. I can iterate on the input xml nodes and do a db insert(pub:db:execSQL), but i don’t think that’s an efficient approach.
Please advice.