This content has been marked as final. Show 2 replies
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',......... )