2 Replies Latest reply: Jan 10, 2013 8:20 AM by kvsinfo RSS

    Custom Authentication resulting in wrong no. of arg error

    kvsinfo
      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!