title: User Input as a Date in Oracle SQL
body: <p>I am trying to get the user to input a code and a date.  The user will first be prompted to enter the code and then the date.  This will display specific information to the user.</p>
  
  <p>I am able to comment out the bottom two lines of code and successfully prompt the user for the code and receive the correct output.  When I uncomment out the bottom two lines of code, it successfully prompts the user for input(which the user would enter the date), but I get a compile error.  </p>
  
  <p>Here is my error I receive: ORA-00932: inconsistent datatypes: expected DATE got NUMBER
  00932. 00000 -  "inconsistent datatypes: expected %s got %s"
  *Cause:     *Action:Error at Line: 22 Column: 44.  </p>
  
  <p>Here is my code:</p>
  
  <pre><code>       WHERE END_CODE.SP_CODE = '&amp;Enter_Code'
         AND
         DATECHART.US_DATE = &amp;Enter_Date;
  </code></pre>