This content has been marked as final. Show 2 replies
The Content and record nodes fall into the default namespace of their parent so you will need to include the namespace references in the XPath as well. Below should be the correct XPath statement for you to use.
This was the code that worked.Thanks A_Non .
Edited by: Rameshkumar T on Nov 30, 2012 10:59 AM
SELECT * FROM XMLTable(XMLNAMESPACES('http://www.taleo.com/ws/integration/toolkit/2011/05' as "n1", 'http://www.taleo.com/ws/integration/toolkit/2005/07/action/export' as "n2"), '/n1:Document/n1:Content/n2:ExportXML/n2:record' passing xmltype( bfilename('TEST','TALEOOUT-12-26.xml') , nls_charset_id('AL32UTF8') ) columns ContestNumber VARCHAR2 (4000) path 'n2:field', Job_Info_JobTypDesc VARCHAR2 (4000) path 'n2:field', JobFamily VARCHAR2 (4000) path 'n2:field',......... )