title: PLSQL function wont return salary where name of the employee is passed in as a parameter
body: <p>Here is my PLSQL function:</p>
  
  <pre><code>Create or Replace FUNCTION getEmpSalary(p_name in VARCHAR)
  Return NUMBER IS
  
      l_return_salary;
      l_salary;
      table_salary NUMBER;
  BEGIN
           Select salary into table_salary from AlphaCoEmp where p_name = p_name;
       return l_return_salary;
  END;
  /
  show errors;
  </code></pre>
  
  <p>I have built a table that holds the following tuples:</p>
  
  <pre><code>NAME              TITLE            SALARY
  ------------------------- --------------------
  Wong                            91296
  Utech                           82058
  Vega                            86858
  Weiser                          79771
  </code></pre>
  
  <p>and am trying to write a PLSQL function to return the salary where the name is passed as parameter.</p>
  
  <p>This is how I am passing as parameter: Note: <em>param1</em> is the name chosen.</p>
  
  <pre><code>exec setEmpSalary(Utech);
  </code></pre>
  
  <p>I am getting the following error(s):</p>
  
  <pre><code>ERROR at line 1:
  ORA-06550: line 1, column 20:
  PLS-00201: identifier 'UTECH' must be declared
  ORA-06550: line 1, column 7:
  PL/SQL: Statement ignored
  </code></pre>
  
  <p>I am unsure as to how this error is being created and could use some help fixing the error. Thanks for your time.</p>