XML Database (MOSC)

MOSC Banner

Inserting XML data into a table

edited Aug 15, 2011 3:38AM in XML Database (MOSC) 3 commentsAnswered
Hi,

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/

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center