title: PL/SQL for parsing EDI (X12, NCPDP, HL7)
body: <p>I have some EDI messages (X12, HL7, etc ...) stored in an Oracle database.  I sometimes want to pull out individual fields (e.g. ISA-03).  Currently, I have some really ugly sql.  I'd like to create a PL/SQL package to make it easier and was wondering if anybody had already done this.</p>
  
  <p>I imagine something like:</p>
  
  <p>select
     edi.x12.extract_field( clob_column, 'ISA', 4)
  from
     edi_table </p>