title: String range is correct, why still get PLS-00215: String length constraints must be in range (1 ..32767)
body: <pre><code>CREATE FUNCTION GET_NAME( V_CODE VARCHAR2) RETURN VARCHAR2
  AS
      NAME VARCHAR2(242);
  BEGIN
      SELECT DISTINCT FACT_NAME
      INTO NAME
      FROM TABLEXXX
      WHERE FACT_CODE = V_CODE;
  RETURN NAME;
  END;
  </code></pre>
  
  <p>Why even defined VARCHA2 with length 242, it still shows this error? Too strange.</p>
  
  <blockquote>
    <p>String length constraints must be in range (1 .. 32767)</p>
  </blockquote>