PL / SQL for EDI Analysis (X12, NCPDP, HL7)

Question

I have several EDI messages (X12, HL7, etc.) stored in an Oracle database. Sometimes I want to pull out individual fields (for example, ISA-03). I currently have a really ugly sql. I would like to create a PL / SQL package to simplify it and wondered if anyone had already done this.

I imagine something like:

select edi.x12.extract_field (clob_column, 'ISA', 4) from edi_table

Answer 1

While I never stored the HL7 message as it is in the database, this should be possible.

HL7 ( XML) , , . "" . HL7 MQHub/eGate . , . .. HL7 , .

.:)

/ .