title: how to declare a date (with time) variable in pl/sql
body: <p>I want to use a date( DD/MM/YYYY HH:MI:SS ) variable in pl/sql. I'm using the following code but it doesn't work : </p>
  
  <pre><code>BEGIN
    declare dateMig date ;
    dateMig  := to_date('19/05/2017 05:05:00', 'DD/MM/YYYY HH:MI:SS');
    exec P_MY_PROC(100,'CHECK',dateMig);
  END;
  </code></pre>
  
  <p>Can anyone help please? what am I doing wrong?</p>