DevOps, CI/CD and Automation

Hi,

i have an XMLTYPE table. When i now want to query the data i get the error ORA-19228: XPST0008 - non declared identifier: Prefix 'sfa' local Name 'sfa:Contact'

XML Data:

<?xml version="1.0" encoding="ISO-8859-15"?>

<ftc:FATCA_OECD version="String" xsi:schemaLocation="urn:oecd:ties:fatca:v1 http://xmlns.oracle.com/xdb/documentation/FatcaXML_v1.1.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ftc="urn:oecd:ties:fatca:v1" xmlns:sfa="urn:oecd:ties:stffatcatypes:v1">

  <ftc:MessageSpec>

    <sfa:TransmittingCountry>LI</sfa:TransmittingCountry>

    <sfa:ReceivingCountry>US</sfa:ReceivingCountry>

    <sfa:MessageType>FATCA</sfa:MessageType>

    <sfa:Contact>Alexander Zelzer</sfa:Contact>

    <sfa:MessageRefId>123456</sfa:MessageRefId>

    <sfa:CorrMessageRefId/>

    <sfa:ReportingPeriod>2014-12-31</sfa:ReportingPeriod>

    <sfa:Timestamp>2015-02-18T16:38:02.000000</sfa:Timestamp>

  </ftc:MessageSpec>

</ftc:FATCA_OECD>

SQL Query:

SELECT msg.contact

FROM itx_ftc_fatca_oecd

   , XMLTABLE(xmlnamespaces('urn:oecd:ties:fatca:v1' AS "ftc", 'urn:oecd:ties:stffatcatypes:v1' AS "sfa"), '/ftc:FATCA_OECD'

     PASSING object_value

     COLUMNS messagespec XMLTYPE PATH '/ftc:FATCA_OECD/ftc:MessageSpec') level1

   , XMLTABLE('/'

     PASSING level1.messagespec

     COLUMNS contact     VARCHAR2(38) PATH 'sfa:Contact') msg

ORDER BY 1;

Has somebody an idea what's wrong?

Many thanks in advance.

Regards,

Martin