Good afternoon,
I am receiving a batch HL7 message, ( contains multiple HL7 messages). THis batch HL7 messages is received as an HL7 and its also received at an XML(Mirth converts HL7 message to XML). So I have 2 versions of the same file - one in HL7 and one in XML. Unfortunately, the XML version is not grouped to where each file is wrapped with each own open/close tags...ie, the, all segments (MSH, PID, ORU, OBX, MSH, PID, etc) are on the same level.
I would like to ingest that batch file into my PLSQL package and process each message, one at a time. parsing each segment and inserting into DB tables. How would I go about doing this? Currently, when I receive single HL7 message, I use the XML version, ingest into PLSQL package, then use XMLTABLE to insert into DB tables. Now that some customers are sending batch versions, I am at a loss as to how to parse into individual messages and insert into DB.
Appreciate any insight ..
Julie