Hi there,
I need help - again.
I'm trying to build a custom authentication (in Apex 4.2), but I get a "PLS-00306: wrong number or types of arguments" error and I don't know why...
Authentication settings are following:
Package is:
create or replace PACKAGE BODY PCK_ELSI_AUTH AS
FUNCTION elsi_authentication(
p\_user\_name VARCHAR2
,p\_password VARCHAR2)
RETURN BOOLEAN
AS
v\_user VARCHAR2(100) := p\_user\_name;
v\_pwd VARCHAR2(100) := p\_password;
v\_lid VARCHAR2(100) := v('P101\_FIRMA');
v\_id NUMBER;
BEGIN
SELECT eid
INTO v\_id
FROM emp
WHERE comp\_id = v\_lid
AND name = v\_user
AND password = v\_pwd;
RETURN v\_pwd = p\_password;
EXCEPTION
WHEN NO\_DATA\_FOUND THEN RETURN FALSE;
END elsi_authentication;
PROCEDURE login_user(
p\_user\_name VARCHAR2
,p\_password VARCHAR2)
AS
v\_user VARCHAR2(100) := p\_user\_name;
v\_pwd VARCHAR2(100) := p\_password;
v\_sess VARCHAR2(100) := v('APP\_SESSION');
v\_app VARCHAR2(100) := v('APP\_ID');
BEGIN
wwv_flow_custom_auth_std.login(
p\_uname => v\_user,
p\_password => v\_pwd,
p\_session\_id => v\_sess,
p\_flow\_page => v\_app || ':1'
);
END login_user;
END PCK_ELSI_AUTH;
And the login process:
BEGIN
IF pck_elsi_auth.elsi_authentication(:P101_USER, :P101_PASSWORD) = TRUE THEN
pck\_elsi\_auth.login\_user (:P101\_USER, :P101\_PASSWORD);
END IF;
END;
Any ideas why I'm getting this error?