DevOps, CI/CD and Automation

Hi,

I have a XML with below content

<Data

    xmlns="http://support.abve.com/misc/axml/2009/06/"

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

    xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:schemaLocation="http://support.aBC.com/misc/axml/2009/06/ http://support.agile.com/misc/axml/2009/06/">

    <AutomatedTransferOrders uniqueId="11761:81908511">

        <CoverPage>

            <AtoType>ATO</AtoType>

            <AtoNumber>ATO123345</AtoNumber>

            <Description>Created by subscriber Qual Sample Workflow Subscriber for Change Orders.</Description>

            <Status>Released</Status>

            <Workflow>Default ATOs</Workflow>

            <Subscriber>Qual Sample Workflow Subscriber for Change Orders</Subscriber>

            <DateOriginated>2016-03-14T02:33:28Z</DateOriginated>

            <DateReleased>2016-03-14T02:33:28Z</DateReleased>

        </CoverPage>

        <SelectedObjects referentId="6000:81908426">

            <Type>ECN</Type>

            <NameNumber>ECN-20932</NameNumber>

            <Description>TESTING ONLY</Description>

            <LifecycleStatus>Released, Awaiting Confirmation</LifecycleStatus>

        </SelectedObjects>

    </AutomatedTransferOrders>

</Data>   

when I try to extract some info using

select extract(xmltype(t.data),'/Data/AutomatedTransferOrders/CoverPage/AtoNumber/text()').getStringVal() from CUST_TEMP t

it will return null,

I have to remove the name space definition

xmlns="http://support.abve.com/misc/axml/2009/06/"

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

xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:schemaLocation="http://support.aBC.com/misc/axml/2009/06/ http://support.agile.com/misc/axml/2009/06/"

to get the info.

Is that the limitation in Oracle XML ?

Thanks

Vincent