title: Why am I receiving a compilation error when executing my PL/SQL Code?
body: <pre><code>create or replace PROCEDURE COMPANYEMPLOYEES 
  (
    in_cname IN VARCHAR2
  ) AS 
    P_RESULT SYS_REFCURSOR;
  BEGIN
    OPEN P_RESULT FOR
      SELECT ename, c.cid, in_cname
      FROM employee e
      JOIN company c on c.cid = e.cid 
      WHERE c.CNAME = in_cname;
    DBMS_SQL.RETURN_RESULT(P_RESULT);
  END COMPANYEMPLOYEES;
  </code></pre>
  
  <p>After you execute the script to create the sproc, you can run this by using the following command </p>
  
  <pre><code>EXEC COMPANYEMPLOYEES ‘Verizon’ 
  </code></pre>
  
  <p>or </p>
  
  <pre><code>EXEC COMPANYEMPLOYEES ‘ATT’
  </code></pre>