Creation of xml (exact globe) from sql for importing invoice

Hi, 

I have to generate an xml for importing invoice into EXACT globe. 

The xml will be generated using a sql code within a task. 

Can you please guide in what should be the CDATA format for the code?

1. I tried below code for processing it: 

'<![CDATA[ ' +cast(i.display_invoice_number as varchar) + ' ]]>' as        Description 

Below is the error after its processed in excat : 

2. Removed the CDATA and sent it as below : 
   CONCAT('< ', cast(i.display_invoice_number as varchar), ' >') as        Description
   Still it was not processed in EXACT, and no error message was provided

3. In the exact knowledge base its mentioned that below characters can be used : 
    

   string

   Strings in XML can contain all normal characters except &, <, >, " and '. These characters need to be replaced by &amp;, &lt;, &gt;, &quot; and &apos; respectively
   
   So updated the Descritption to below code :
   
    '<![CDATA[ ' +cast(i.display_invoice_number as varchar) + ' ]]>' as     Description
   The output after processed in Exact : 
    

   

Can someone please guide?