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
IF UPPER(pUser) = UPPER(pPass) THEN
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!
in such cases, it is always helpful to run the application in debug mode. It should show you how Apex calls your function. The reason for the PLS-00306 is probably that the engine tries to call your function with named arguments p_username and p_password, not pUser/pPass.