title: I am new to PL/SQL.Can some one help me in this PL/SQL procedure?
body: <p>Write a PL/SQL procedure which takes employee number and salary as input parameters and delete from employees table whose manager is 'BLAKE' and salary between 1000 and 2000.</p>
  
  <p>I have written below code :-</p>
  
  <pre><code>create  or replace procedure processing(v_emp_no in emp1.empno%type,v_salary in emp1.sal%type)
  is 
  begin
  
  select empno,sal into v_emp_no,v_salary
  from emp where ename = 'BLAKE' and sal between 1000 and 2000;
  delete from emp1
  where empno  = v_emp_no
  and sal = v_salary; 
  end;
  </code></pre>
  
  <p>Getting below error :- </p>
  
  <blockquote>
    <p>Error at line 5: PLS-00403: expression 'V_EMP_NO' cannot be used as an INTO-target of a SELECT/FETCH statement</p>
  </blockquote>