Example 12-10: Serving AuthorizationRequest datagrams

<?xml version="1.0"?>
<!-- creditcardauth.xsql -->
<?xml-stylesheet type="text/xsl" href="rowset-to-creditcardauth.xsl"?>
<xsql:query xmlns:xsql="urn:oracle-xsql" connection="xmlbook"  max-rows="1" >

  SELECT card_number,exp_month,exp_year,amount,
         currency,merchant_id,
         /* Use TO_CHAR to format date as we want it in resulting XML */
         TO_CHAR(request_date,'DD-MM-YYYY HH24:MI:SS') as request_date
    FROM authorization_request
   WHERE request_id = {@id}
  
</xsql:query>