PL / SQL - Incorrect number of argument types in the call

Question

PL / SQL - Incorrect number of argument types in the call

Navigation

#1 by (1 votes)

1

I'm having a problem with a simple function that I created.

create or replace FUNCTION dry_login (
    username IN VARCHAR2,
    password IN VARCHAR2 )
RETURN BOOLEAN
IS
    l_user varchar2(70);
    l_pwd  varchar2(70);
BEGIN
  SELECT usuario_nome, usuario_senha
    INTO l_user, l_pwd
    FROM dry_usuario
  WHERE usuario_nome = username;

IF (l_pwd = password) and (l_user = username) THEN
    RETURN TRUE;
ELSE
    RETURN FALSE;
END IF;
EXCEPTION
    WHEN NO_DATA_FOUND THEN RETURN FALSE;
END;

Give the following error:

ORA-06550: line 4, column 23: PLS-00306: Incorrect number of argument types in call to 'DRY_LOGIN' ORA-06550: row 4, column 1: PL / SQL: Statement ignored

Someone help me find this error, please. Thank you. Att Oliver

oracle pl-sql

asked by anonymous 26.05.2017 / 16:29

1 answer

Add new fields in migration? Unity installation is giving error

score 1 · Answer 1

I checked APEX and saw that the name of the parameter is already defined in the method call. The tip is in case anyone needs it, I made the following change.

create or replace FUNCTION dry_login (
    p_username IN VARCHAR2,
    p_password IN VARCHAR2 )

Thanks for the attention and help of everyone.