title: How can I insert Date Time with WSO2 Data Service in Oracle
body: <p>I need to insert datetime information with WSO2 Data Service in Oracle date field. I created an Oracle procedure to insert a record.</p>
  
  <p>The WSO2 map considers:       </p>
  
  <pre><code>&lt; param name="execution" sqlType="DATE" ordinal="17" /&gt;
  </code></pre>
  
  <p>And for execute the DS, I used:       </p>
  
  <pre><code>&lt; xs:execution xmlns:xs="ds.exec.com.br"&gt;2011-04-01T08:10:00&lt;/xs:execution&gt;
  </code></pre>
  
  <p>I tried use the query like this:</p>
  
  <pre><code>INSERT INTO xxxx (execution) 
       VALUES (to_date(p_execution,'yyyy-mm-dd hh24:mi:ss'));
  </code></pre>
  
  <p>Someone can help-me please?</p>