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.
I have written below 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;
Getting below error :-
Error at line 5: PLS-00403: expression 'V_EMP_NO' cannot be used as an INTO-target of a SELECT/FETCH statement