ORA-06553: PLS-306: wrong number or types of arguments in call

ORA-06553: PLS-306: wrong number or types of arguments in call to

ORA-06553: PLS-306: wrong number or types of arguments in call to

Cause:

An Oracle function was referenced with an incorrect number of arguments.

Solution:

Correct the syntax of the function by entering the required number of arguments.

Example:

create or replace function TEST(p_id number)
return varchar2 as
	v_name varchar2(250);
begin
	select name 
	into v_name 
	from employees 
	where id = p_id;
	return v_name;
end;

SELECT test(1,2) FROM dual;

Output:

ORA-06553: PLS-306: wrong number or types of arguments in call to ‘TEST’

Correct

SELECT test(1) FROM dual;