gistfile1.txt

tab has 1 xml column

rough code - but real code works and has this same format

insert into tab
with cte as
  (select *
   from xmltable(....  passing xmlparse(document cast(? as clob)) as ...   <====== parameter has very long xml I need to split
                 columns
                 c1 xml path ...
                 c2 xml path ...
                )
  )
(select xmldocument(xmlelement(name ... xmlelement(name "xx", c1) ...
 from cte
 fetch first 1 row only
)
union all
(select xmldocument(c2)
 from cte
);