Generate XML Data with SQL query using XML tags

<?xml version="1.0" encoding="WINDOWS-1252" ?>

- <dataTemplate name="XXXXXSMSN" description="XXX Signup Notification" version="1.0">

- <parameters>

<parameter name="P_ORDER_HEADER_ID" dataType="NUMBER" />

</parameters>

- <dataQuery>

- <sqlStatement name="Q_MAIN">

- <![CDATA[

 select ooh.CUST_PO_NUMBER
                            ,ooh.ORDER_NUMBER
                            ,TO_CHAR(ooh.ORDERED_DATE, 'MM/DD/YYYY')   ORDERED_DA                        from OE_ORDER_HEADERS_ALL   ooh

                      where ooh.header_id          = :P_ORDER_HEADER_ID     

]]>

</sqlStatement>

</dataQuery>

</dataTemplate>