Inserting XML data into a table
I have created an XSLT to transform XML data to ROWSET/ROW xml data which will be inserted later into a table. The problem is that the XSLT produces the ROWSET/ROW structure but the elements do not have values. The following are a sample code and the result. Can you help please?
Thanks,
CREATE OR REPLACE PROCEDURE TEST
ISl_v_xml XMLTYPE :=XMLTYPE('<?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><GetAxaptaViewAsStringResponse xmlns="http://Matiq.Datafangst.WebService/