CREATE OR REPLACE PROCEDURE disp_emp_details (
iempno IN NUMBER,
semail OUT VARCHAR2,
ssalary OUT VARCHAR2
) IS
lv_count NUMBER(10);
invalid_emp EXCEPTION;
BEGIN
SELECT
employee_id
INTO lv_count
FROM
hr.employees
WHERE
employee_id = iempno;
IF lv_count IS NULL THEN
RAISE invalid_emp;
ELSE
EXECUTE IMMEDIATE 'Select employee_id, email, salary from hr.employees';
END IF;
EXCEPTION
WHEN invalid_emp THEN
dbms_output.put_line('Record Not Found');
END;
I am executing using exec DISP_EMP_DETAILS(198);