title: How to start procedure in oracle?
body: <p>So I have this SELECT statement:</p>
  
  <pre><code>     SELECT emp.emp_name, pos_emp.POSITION_NAME
       from EMPLOYEE emp
       join POSITION_EMPLOYEE pos_emp
       on emp.POSITION_EMPLOYEE_POSITION_ID=pos_emp.POSITION_ID
       where emp.EMP_NAME='&amp;employee_name';
  </code></pre>
  
  <p>When I enter employee name from keyboard it returns me his name(from EMPLOYEE table) and position(from POSITION_EMPLOYEE table). But I want to do this with stored procedure:</p>
  
  <pre><code>    create or replace PROCEDURE emp_pos(   EMPLOYEE_NAME IN EMPLOYEE.EMP_NAME%TYPE,
                                         POSITION_NAME OUT POSITION_EMPLOYEE.POSITION_NAME%TYPE )
  AS
  BEGIN
      SELECT pos_emp.POSITION_NAME
      INTO
          POSITION_NAME
      FROM EMPLOYEE emp
          JOIN
              POSITION_EMPLOYEE pos_emp
              ON
                  emp.POSITION_EMPLOYEE_POSITION_ID 
                  = pos_emp.POSITION_ID
      WHERE emp.EMP_NAME 
            = EMPLOYEE_NAME
      ;
  
  END;
  </code></pre>
  
  <p>I am trying to start the procedure with begin:</p>
  
  <pre><code>begin emp_pos('&amp;employee_name');
  end;
  </code></pre>
  
  <p>The compiler gives me error:wrong number or types of arguments in call to 'EMP_POS'. Where am I wrong?</p>