Creating an EDI doc from XML
We are receiving invoices as XML docs from customers which we are dropping into a CLOB in our Oracle 9i DB. We then have to turn around and create an EDI text document out of it by parsing the XML and putting specific elements into the correct place in the EDI doc (which is basically an ASCII file with a very specific format often delimited by asterisks--each line starting with a tag that has a certain meaning). It is a mapping exercise from XML elements to specific locations in the EDI file. I have been considering the pros and cons of using DOM parsing vs. XSL Transformations. Are there other good ways of parsing XML that I should be considering? Thanks,
Steve