title: Error: PLS-00103: Encountered the symbol ")" when expecting one of the following
body: <p>When I press F8 in PL/SQL developer for Package MyPackage creation I get below error</p>
  
  <pre><code>Error: PLS-00103: Encountered the symbol ")" when expecting one of the following:
  
            &lt;an identifier&gt; &lt;a double-quoted delimited-identifier&gt;
            current delete exists prior
  Line: 24
  Text: FUNCTION MyFunction() RETURN VARCHAR;
  </code></pre>
  
  <p>Below is the code</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE MyPackage AS
  FUNCTION MyFunction() RETURN VARCHAR;
  END MyPackage;
  
  CREATE OR REPLACE PACKAGE BODY MyPackage AS
  
  FUNCTION MyFunction RETURN VARCHAR2 IS
          l_pram mytable.param_val%TYPE;
      BEGIN
          SELECT SomeColumnVal INTO l_pram FROM mytable WHERE SomeColumn = 'SomeValue';
          RETURN l_pram;
  END MyFunction; 
  
  END MyPackageBody;
  </code></pre>