DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Complex xml with multiple namespaces giving LPX-00601: Invalid token error

NickiKNov 20 2014 — edited Nov 20 2014

Apologies if this is a really simple question.

I have not worked with xml before and I'm drowning in different ways to do the extract.

I have a very complex xml, sample below, which I'm trying to do one siple extract to get myself going.

I have the data in a table in an xmltype column,

I am trying to extract containernumber first and get the error.

select xml_column, extract(xml_column,'/env:Envelope/env:Body/ns0:QueryCntrNumberResponse/ns0:QueryResContainerDetail/ns1:ContainerNumber/ns2:ContainerNumber')

from test_xml;

Not sure if I should use the namespaces and have tried without but results are always NULL

I would really appreciate any pointers around these ultiple namespaces.

Thanks

Nicki

XML Sample

<?xml version="1.0" encoding="UTF-8"?>

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"

xmlns:xsd="http://www.w3.org/2001/XMLSchema"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:ns0="http://com.cargosmart.cargotracking.webservice.cntr.dto"

xmlns:ns1="http://com.cargosmart.cargotracking.webservice.common.dto"