title: No PL/SQL translation for the bindtype given for this bind variable
body: <p>I am working on reports oracle 11g and applying formula as follows</p>
  
  <pre><code>function CF_CLEAR_EMP_NAMEFormula return Char is
      V_EMP_DESC VARCHAR2(1500);
  BEGIN
      pkg_lkp.p_emp(:P_Lang,TO_CHAR(:emp_serno1),V_EMP_DESC);     
      RETURN INITCAP(V_EMP_DESC); 
  EXCEPTION
      WHEN OTHERS THEN
      NULL;
  END;
  </code></pre>
  
  <p>and when I compile it gives me this error I checked :emp_serno1 type and formula type and no clue what happens when I change :emp_serno1 to :emp_serno which in other query it compiles but that's not what I want.</p>
  
  <blockquote>
    <p>no PL/SQL translation for the bindtype given for this bind variable</p>
  </blockquote>
  
  <p>I checked the error description on the internet:</p>
  
  <p><strong>Cause</strong>: A host variable was passed (by an
  Oracle Precompiler program, for example) to PL/SQL for binding. However, its
  datatype is not compatible with any PL/SQL datatype. So, the binding
  failed.
  <strong>Action</strong>: Change the datatype of the host
  variable to make it compatible with a PL/SQL datatype.</p>