Using Oracle PL SQL to bulk load XML

In performance testing it is often necessary to do bulk loads of data into databases via XML payloads, to prepare for a test. For my example I had to load 250,000 elements via XML to create accounts. The XML structure had one root or top level element with many child elements, also many batches of the root elements. I decided I would perform a commit after constructing each root element, with the corresponding amounts of child elements. I made both the batch number of root elements and the child elements both configurable. This resulted in the following PL SQL code. I have deleted out certain parts of the XML so as to protect client.
Continue reading “Using Oracle PL SQL to bulk load XML”

XML and WSDL Validation

If you are looking to  perform either of these functions then go no further than downloading the free Java IDE tools, Eclipse or Netbeans. Both of these have adequate functionality for validating XMLs and WSDLs. The latest review on the comparison of these two tools is that they both compare almost on par. Therefore up to you on which one you download. I chose NetBeans so, download from here NetBeans or if you prefer Eclipse

To validate from Netbeans:
1. From main menu select File->Open and select the file to validate
2. Select the validate XML icon
3. Check the Output:XML Check window for errors