Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting error 'wrong number or types of arguments in call to 'DISP_EMP_DETAILS' while calling a SP

Albert ChaoSep 3 2021
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);

Comments
Post Details
Added on Sep 3 2021
5 comments
7,754 views