title: Getting ORA-01861 - Literal does not match format string on SQLPlus Only
body: <p>I have a PL/SQL procedure that takes the following arguments/parameters</p>
  
  <pre><code>Procedure create_test(mode_in in number, value1_in in number, 
          value2_in in number, value3_in in varchar2);
  </code></pre>
  
  <p>I am using the following pl/sql block to call and execute the procedure</p>
  
  <pre><code>DECLARE
    lv_mode NUMBER;
    lv_value1_in NUMBER;
    lv_value2_in NUMBER;
    lv_value3 VARCHAR2(3);
  BEGIN
    lv_mode := 1;
    lv_value1_in := 1;
    lv_value2_in := 1;
    lv_value3_in := 'ES';
  
    CREATE_TEST(
      mode_in =&gt; lv_mode ,
      value1_in =&gt; lv_value1_in,
      value2_in =&gt; lv_value2_in,
      value3_in =&gt; lv_value3_in
    );
  --rollback; 
  END;
  /
  </code></pre>
  
  <p>If i paste the above sql block into SQLDeveloper and execute it, it runs with no problems. 
  If i put it in a file and execute it through SQL plus, i get the following error (same problem if run it directly in SQLPLus):</p>
  
  <pre><code>ORA-01861: literal does not match format string
  </code></pre>
  
  <p>Usually when i get this error, the issue is usually related to Dates. I am not sure what is wrong with the above as there are no dates involved - Especially given the fact that the same SQL block works in an IDE but not SQLPLus. 
  Is SQLPlus handling the literals slightly differently than the IDE? </p>
  
  <p>My guess is that some parameter in SQLPlus is handling it differently - but which one?</p>