title: passing parameter but unable to fetch?
body: <p>how to resolve this one, unable to fetch ?
    I am passing the IN parameter but still unable to fetch.                   </p>
  
  <pre><code> create or replace procedure p1(p_ename in varchar2,p_sal out number)is
   begin
    select salary into p_sal from employees where last_name=p_ename;
   dbms_output.put_line(p_sal);
   end;
  
   variable b number;
   execute p1('King',:b);
  
  
  [info](https://infoallsite.wordpress.com/2016/01/29/unable-to-fetch- data)
  
  
   [error][1]
  
   ' got error ,but only one row has last_name as King, '
    how to resolve I  want  to get the salary of king.
    [1]: http://i.stack.imgur.com/AsOHG.png'
  </code></pre>