This discussion is archived
2 Replies Latest reply: Jan 10, 2013 6:20 AM by 980912 RSS

Custom Authentication resulting in wrong no. of arg error

980912 Newbie
Currently Being Moderated
Hi,
I'm using 11gr2, apex 4.2 conneced thru pl/sql gateway and using theme 24.

I wrote a simple function

create or replace function apex_check_user(pUser VARCHAR2,pPass VARCHAR2)
RETURN BOOLEAN IS
BEGIN
IF UPPER(pUser) = UPPER(pPass) THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
END;
/

I created a new auth scheme with all defaults except for
scheme type: Custom
auth function name = apex_check_user
enable legacy auth attribute = no (this is the default)

when I run the app I get the error below:
ORA-06550: line 4, column 23: PLS-00306: wrong number or types of arguments in call to 'APEX_CHECK_USER' ORA-06550: line 4, column 1: PL/SQL: Statement ignored

Do I need to pass the username/pass on the function name? everthing I see so far including the help just says type the function name with no parameter.

thanks in advance!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points