Change it into something like:
Code:create or replace procedure Emp_Procedure (p_empno in number) AS v_ename emp.ename%TYPE; begin select ename INTO v_ename from emp where empno = P_empno; dbms_output.put_line('this the employee I want to is ' ||' ' ||v_ename ); end;




Reply With Quote