title: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 5
body: <pre><code>   set serveroutput on;  
     set verify off;  
     set autoprint on;  
     variable b_employee_id employees.employee_id%type;  
  declare  
     v_last_name employees.last_name%type;  
     v_emp_id employees.employee_id%type;   
     begin  
     select employee_id into :b_employee_id from employees   
     where last_name='&amp;v_last_name';   
  
    end;  
  /  
  </code></pre>